AD 98-21-21 R1
Registered aircraft · 85,612
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N2RTBarnett Keri Trustee · Brownfield, TXN2RXJbs Enterprises LLC · Hamilton, MTN2SBMarz Richard F · Statesboro, GAN2SLLowe Aviation LLC · Bountiful, UTN2SSFlying M Aircraft LLC · Kuna, IDN2SVPiper J D · Lawrenceville, ILN2SXCastello Gregory R · Spencer, WVN2TDRds LLC · Strongsville, OHN2TLAlexander Terry W · Hayward, CAN2TPHanchett James R · Cheboygan, MIN2UGBaker Gregory L · Hilton Head Island, SCN2UMHepfer John Edward · Midland, TXN2UNSuriel Darleny G · New York, NYN2UTDemaeyer Thomas A · Fort Lauderdale, FLN2VCPray Aviation Inc · Augusta, KSN2VGWong Jonathan · Phoenix, AZN2VQN2vq LLC · Manassas, VAN2VRRead Andrew R · Milwaukee, WIN2VVAir Mods And Repair Inc · Robbinsville, NJN2VZUrbizu Carlos A · Tampa, FLN2WSeldom Seen Aviation Northwest Inc · Stevensville, MTN2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEN2WTJohnson Michael A · Winter Park, CON2XCMiller Virgil J · Milton Freewater, ORN2XHAmericas Best Amt Inc · Goodyear, AZN2XNDudebuddy Aviation LLC · Kalispell, MTN2XRInternational Air Services Inc Trustee · Carson City, NVN2XSCarter Delton W · Montgomery, TXN2XXTyler James · Oklahoma City, OKN2YCTaglavore Franklin · Irving, TXN2YEAllied Moulded Products Inc · Bryan, OHN2YPCollum Aviation LLC · Milton, FLN2YROverland Missions Inc · Cocoa, FLN2YYRd Enterprises LLC · Blacksburg, SCN2ZTwo Zulu LLC · Mclean, VAN2ZDMelin Lynn Glenn · Scottsdale, AZN2ZWThordarson Gudsteinn Thor · La Porte, INN30005Hein Tanner T · Clayton, NCN30007Snow Carol A · Rattan, OKN30009Mock Joseph R · Huntsville, TXN3000AWeeks Grp LLC · Summerland Key, FLN3000FNosense LLC · Kalispell, MTN3000KRon Aire LLC · Preston, MNN3000QFlying H Enterprises · Santa Fe, NMN3000UMerrell Warren W · Idalou, TXN3000YChesebro Ben D · Tucson, AZN30012Wfc Aviation Inc · Johnstown, PAN30015N30015 LLC · Saunderstown, RIN3001CHoyt Robert H · Canby, ORN3001KHauck Drew Steven · Buffalo, MN
Back to AD 98-21-21 R1