AD 98-08-25 R1
Registered aircraft · 286
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-08-25-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-08-25-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-08-25-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-08-25-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.
N29GADelaurentis Robert Gerard · San Diego, CAN29GDAriel Seafoods Aviation LLC · Destin, FLN29PRGa Flying LLC · Kalispell, MTN2BZBosco74 LLC · Wilmington, DEN30854Cornerstone Financial Enterprises LLC · Mesquite, NVN31BVCourtney Aviation LLC · Columbia, CAN32ALAero Air LLC · Hillsboro, ORN32GASpur Aviation Services Lc · Twin Falls, IDN32GLG E Air Inc · Broussard, LAN32WSPonderosa Aviation LLC · Safford, AZN333UPEverel Airborne LLC · Sandia Park, NMN33PGFoundation Of Wayne Community College Inc · Goldsboro, NCN362SHFlight-Plan One LLC · Bay City, MIN364WAAerokinetical Aviators LLC · West Chester, OHN36JFMmdex LLC · Carlisle, PAN36JTAerial Surveys International LLC · Watkins, CON37SBZb Investments Ltd · Dallas, TXN383HCAc690 LLC · Alpine, WYN3869FElkhorn Aviation Inc · Baker City, ORN38LMKoy Dean · Houston, TXN38WAAirborne Support Inc · Houma, LAN39GWKotalite Consultant LLC · West Palm Beach, FLN3NTSpur Aviation Services Lc · Twin Falls, IDN3UVPonderosa Aviation LLC · Safford, AZN400DSSpur Aviation Services Lc · Twin Falls, IDN40SMCo Fire Aviation Leasing Inc · Fort Morgan, CON420LWCrazy Horse LLC · Princeton, WVN425DTSun Fast Inc · Mansfield, TXN42MSPlukair Texas LLC · Houston, TXN42NZCo Fire Aviation Leasing Inc · Fort Morgan, CON444TSUig Transport LLC · Raleigh, NCN444WDFlyto LLC · Indianapolis, INN449LCTj Air Holdings Inc Trustee · Wilmington, DEN44NCPonderosa Aviation LLC · Safford, AZN45AZPonderosa Aviation LLC · Safford, AZN4717VCourtney Aviation LLC · Columbia, CAN479PTT Enterprises Inc · Jackson, MSN47ACReabe Aircraft Improvement Inc · De Pere, WIN47EPRum Bum Distributors Inc · Miami, FLN47TTLon Air LLC · Miles City, MTN480KSpur Aviation Services Lc · Twin Falls, IDN48BANjia Air LLC · Montgomery, INN4QSPonderosa Aviation LLC · Safford, AZN500HMTalos Aviation Group LLC · Blackstone, VAN500RXGiesler Gary J · Hermann, MON500SJAir Data Solutions LLC · Natchitoches, LAN500VEGame On Aviation LLC · Charlotte, NCN5016HBest Aircraft Deals LLC · Salt Lake City, UTN507JPShrike Comm LLC · Matthews, NCN50DXYada Yada Yada Inc DBA · Fresno, CA
Back to AD 98-08-25 R1