AD 98-21-21 R1
Registered aircraft · 85,620
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.
N1708TN1708t Owners Assn · Chesapeake, VAN1708WCassaday Jonathan A · Visalia, CAN1709CDmj Holdings LLC · Kalispell, MTN1709JWingman Unlimited LLC · Carrollton, TXN170AWyrick Randall D · Fairland, OKN170ACBrett Price Excavating Inc · Rigby, IDN170AGHuber David C · Victoria, TXN170AKPerry John E · Kenai, AKN170ARSmith Edward T · Bradenton, FLN170ASBowe Rick J Trustee · Chippewa Falls, WIN170ATVan Anda Aviation LLC · Apopka, FLN170AWAir Alaska Properties · Wasilla, AKN170BRegistered aircraftN170BBSmothers Joey D · Dwight, ILN170BESmith Michael E · Willits, CAN170BGFinley Rory P · Loon Lake, WAN170BHAero-Mobil Inc · Wilmington, DEN170BKDugan Robert J · Boulder City, NVN170BSMcintyre James C · Bethlehem, PAN170BTSparks Richard M · Wasilla, AKN170CFAbes Erika · El Paso, TXN170CLHickle William H · Inyokern, CAN170CPLawrence Wyatt · White House, TNN170CWHohmann Courtney P · Jacksonville, FLN170DWarr Victor L · Star, IDN170DFWilliams John S · Cleveland, TXN170DGBush Horizon Inc Trustee · Wilmington, DEN170DMBarnstorm/T-34 LLC · Jacksonville, FLN170DPLeingang Mark J · Olympia, WAN170DWBelden George B · Sonoma, CAN170ECMueller Brent · Saint Maries, IDN170EEDowd Darin R · Gainesville, TXN170ERBowles Brent J · Iraan, TXN170ETPalmatier Harry C III · Volant, PAN170FGs Aviation Inc · Stilwell, KSN170FMMain Freddie L II · Trophy Club, TXN170FSShe-Rat Aviation Inc · Wilmington, DEN170GKipp Robert C · Woodinville, WAN170GAOtey Neil F · White Bear Lake, MNN170GCWiley Calvin B · Summer Shade, KYN170HPKoven Mark Lee · Logan, UTN170HSAero Leasing LLC · Brandon, MSN170HTJon Gibson Co · Cameron Park, CAN170JGivens Steve W · Pendleton, INN170JACrosby Kenneth R · Trapper Creek, AKN170JBEmmons Carl E · Nome, AKN170JEBarrett John E · St Charles, ILN170JGErbey Donald L · Wasilla, AKN170JKSchreier James J · Fort Dodge, IAN170JLGodes Terry J · Soldotna, AK
Back to AD 98-21-21 R1