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.
N972FGRidgeline Assets LLC · Wilmington, DEN972GJPolk County Sheriffs Office · Winter Haven, FLN972GLWelch Gary A · Groveland, CAN972KCMustang Sally Aviation LLC · Camden, SCN972LTUniversity Of La System DBA · Ruston, LAN972NCIal Corp · Lewes, DEN972PGLaw Office Of Thamir A R Kaddouri Jr P A · Albany, GAN972PMNp Aviation Inc · Naguabo, PRN972RTMellott Stephen G · Berthoud, CON972SALindeman Inc · D'Hanis, TXN972TAConfluence Systems Consulting · San Jose, CAN972THUtah State University · Logan, UTN972WWChapel Hill Flying Club Inc DBA · Sanford, NCN9730DFlood Ashley · Gibbstown, NJN9730LSundowner N9730l LLC · Calhoun, GAN9730PDreger Dean R · Wilbur, WAN9730QWheat Land Aviation LLC · Andover, KSN9730USherry-Aire LLC · Sidney, MTN9730VWings Over Texas Holdings LLC · Denton, TXN97313Civil Air Patrol Inc · Maxwell Afb, ALN9731FN9731f LLC · Stuart, FLN9731HCreative Strategies Inc · Proctorville, OHN9731LMaine Instrument Flight · Augusta, MEN9731MHausaman Jeffrey S · Las Vegas, NVN9731UNatale Louis H · Cedar Park, TXN9731WDacy David M · Harvard, ILN9732DTouzeau Raymond V · Newberg, ORN9732HLand & Leave LLC · Helena, MTN9732JWalborn Gary D · Youngstown, OHN9732VSiguaw Robert E · Deming, WAN9732WFlying Elvis · Jacksonville, FLN9733ACloud Dancer Aviation Inc · Deland, FLN9733DMcfalls Caleb Parker · York, SCN9733LStock Craig A · Devon, PAN9733MJc Mooney LLC · Tallahassee, FLN9733VTyler Ronald J · Martville, NYN9733WWilson Lyndon K Sr · Ringgold, GAN9734BPreston Aviation LLC · Henderson, KYN9734JPiper Perfect LLC · Panama City, FLN9734MHaddle Eddie · Lindon, UTN9734PHornyak Ryan J · Girard, PAN9734USls Aviation LLC · Poquoson, VAN9734WNimbus Air LLC · Frankfort, ILN97358Rick Aviation Inc · Newport News, VAN9735DSkinner Timothy G · Archer, FLN9735PSprenger Mark R · Eagle River, AKN9735UFreeman George W · Wolcottville, INN9736DCamp Doug A · Starkville, MSN9736QGregory Charlie E · Blairsville, GAN9737DFolkvord Darrel L · Toston, MT
Back to AD 81-18-04 R2