AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N98HPJds Aero LLC · Decatur, TXN98HSSaunders Robert A · Barrington, RIN98HUAviat Aircraft Inc · Afton, WYN98HYDemers Trampas · Shelburne, VTN98JGDistrict Board Of Trustees Miami Dade College Fl · Miami, FLN98JSErstad Eldon D · Maple Lake, MNN98JZIvy Steven D · Sealy, TXN98KPDoane Gerald H · Orrington, MEN98MLPlr Services LLC · Stuart, FLN98MSSparks Carl A · Branson, MON98MVFargo Jet Center LLC · Fargo, NDN98NTTurner Lawrence L · Fallon, NVN98PFDakota Acre Farms Inc · Denhoff, NDN98PGJackson James K Sr · Tetonia, IDN98PKSullivan David M · West Ossipee, NHN98RDRoute 66 Aerostars LLC · Galena, KSN98RHHart Roger T · Erie, CON98RKKeith Robert W · Austin, TXN98RVFormanek Carl F · Glen Flora, WIN98SATail Slide Aviation LLC · Wilmington, DEN98SWGankas Christopher · Ventura, CAN98TDLewis John Cory · Modesto, CAN98TFSweeney Sean M · Reunion, FLN98TMKeithley Richard S · Brentwood, CAN98TVJoint Air-Ground Solutions Inc · Richmond Hill, GAN98VFFitzpatrick Patrick D · Titusville, FLN98VLVortex Leasing LLC · Racine, WIN98VPParrish Joseph C · Pasadena, CAN98VRLucroy Robert H · Georgetown, TXN98WHN94ee LLC · West Palm Beach, FLN98WLN7876p LLC · Monument, CON98WWSmith Kent L · Doniphan, MON98WYCheyenne Flying Club LLC · Cheyenne, WYN98ZTSharp Paul A II · Apollo Beach, FLN9900KLong Jimmie Brian · Cropwell, ALN9900LWalters Linn Robert · Malabar, FLN9900MGoldfinch Aviation LLC · Mukilteo, WAN9900QBedsole Clinton Allen · Frisco, TXN9900UMeyer Mark · Scotts Valley, CAN9900WGinther Wallace S · Quincy, ILN9901LWachsmuth Dawson T · West Ossipee, NHN9901WWilliams Air Power Inc · Lowell, MIN9902QBowers John E · Owasso, OKN9902UHamaker George E Jr · Birmingham, ALN9902WDavis Robert D · Murfreesboro, TNN9902YJeepers LLC · New York, NYN99031Diamond X LLC · Elko, NVN9903LAdams Alfred E · Greenville, NCN9903VDwh Flight LLC · Spring, TXN99040Bradley Aircraft Company LLC · Columbus, IN
Back to AD 81-18-04 R2