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.
N937EREmbry-Riddle Aeronautical University · Daytona Beach, FLN937LTAerosim Flight Academy · Sanford, FLN937MAMacair Aviation LLC · Xenia, OHN937SAAdvanced Aviation Group LLC · Frederick, MDN937SCAb Prop Plane I LLC · Metairie, LAN937TEPicton Aaron · Redding, CAN9380JMay Theodore R · Mcloud, OKN9380MSmith Ralph · Bel Air, MDN9380WDg Aviation LLC · Mansfield, TXN9381DRubbert Randy C · Reynolds, NDN9381J2208 Juliet Inc · Redwood Falls, MNN9381LRyback Andrew · Ocala, FLN9382DN9382d LLC · Wake Forest, NCN9382LCox Steven G · Colorado Springs, CON9382MBonifay Jason · Corona Del Mar, CAN9382NGarapati Prasad S · Mount Airy, MDN9382VWesterhold Wayne E · Cary, NCN9382WTraum Air LLC · Colorado Springs, CON93831Christiansen Aviation LLC · Wilmington, DEN9383JBarrowman John L · Tucson, AZN9383LRegistration Pending · Omaha, NERegistration pendingN9383MTitle Benjamin H · Arlington, VAN9383NHall John G · Morrilton, ARN9383WJoecks David W · Del Norte, CON9384DDel Aero Service Inc · Delta, UTN9384JCrayviation LLC · Leesburg, VAN9384LBethel Thomas G N · Moultonborough, NHN9384MNorfolk Aviation LLC · Norfolk, VAN9385FReynolds Darryl G · Wills Point, TXN9385JDauzat Robbie A · Pineville, LAN9385LFixed Wing Holding Co Inc · Pembroke Pines, FLN9386JWilkes Flying Club Inc · Wilkesboro, NCN9386LMiller Michael C · Bullard, TXN9386MWhite Jason · Lewes, DEN9386NMays David J · Lincolnton, NCN9386REnsing Maris J · Orange, CAN9386VSwaney Matthew P · Thomasville, NCN9387DPrecise Flight LLC · Waukesha, WIN9387HAirline Transport Professionals Corp Of USA · Wilmington, DEN9387JBetzold Michael K · Anchorage, AKN9387MKastner Doug · Prineville, ORN9387TAnczarski John J · Ringtown, PAN9387VPabst Erik R · Claremont, CAN9388MN9388m LLC · Sheridan, WYN9389DAirmotive Service LLC · Brigham City, UTN9389ELandr One LLC · Bozeman, MTN9389JRaymer Michael D · Paris, TNN9389LL A M Capital Management LLC · Sheridan, WYN9389MRutledge Richard L · Hurst, TXN9389VAllen Jeffrey W · Crestwood, KY
Back to AD 81-18-04 R2