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.
N6675ZBoomer Aviation Inc · Fort Walton Beach, FLN6676JRozof Chester F · Fort Myers, FLN6676RJackson Michael W · Bedford, TXN6676WWorkman Industries Inc · Durant, IAN6677HPeterson Robert E · Richland, WAN6677WOsgood Darrell F · Watervliet, MIN6678FAircraft Guaranty Corp Trustee · Oklahoma City, OKN6678JWiener Ronald K · Tucson, AZN6678WMadison Andrew J · Inver Grove, MNN6679PJmj Aviation LLC · Kalispell, MTN6679UKimbrough Edward W · Houston, TXN667ABlaschka Michael T · Medford, ORFirst renewal noticeN667BAAmendala Brian R · Hillsboro, ORN667BLClover Park Technical College · Lakewood, WAN667CPCivil Air Patrol · Maxwell Afb, ALN667CRKnieling Gene A · Rush Center, KSN667DTGinter Jon A · Marlton, NJN667EREmbry-Riddle Aeronautical University Inc · Prescott, AZN667LBChristiansen Aviation LLC · Wilmington, DEN667LDLeading Edge Aviation LLC · Manchester, MON667QTevik Michael A · Provo, UTN667SAHelicopter N667sa LLC · Lisbon, NDN667SCSpartan Education LLC · Tulsa, OKN667SPHindi David · Cupertino, CAN667TCT J Aviation LLC · Kennesaw, GAN6680EPrax Philip · Fairbanks, AKN6680JElliott Bryn · Blue Point, NYN6680PWilliams Aaron J · Addison, TXN6680RWestlake Mark A · Jewett, OHN6681PHouse Charles D · Tunkhannock, PAN6681UGriffin Josh R · Minot, NDN6681XSky Harbor Aviation LLC · Powder Springs, GAN6682LDeyo Kenneth F · Thomaston, CTN6682RCavazos Jose Luis Jr · Houston, TXN66836Wolgemuth Jim · Anchorage, AKN6683UReisner Kenneth D · Lecompte, LAN66842Gelvin Stanley M · Central, AKN6684PN6684p LLC · Kalispell, MTN6684RRoberts Alec · Boulder, CON6684UFowler Kenneth G · Newport, TNN6684WWaltman Richard Dean · Moses Lake, WAFirst renewal noticeN6685UMccroskey Wesley D · Kingston, TNN6685WZulueta David · Louisville, GAN6686LHartmann Peter F · Paulden, AZN6686RAnderson Benjamin P · Bellevue, NEN6686UNorstegaard Mark A · Sturgis, SDN6687CHurtt Ben J · Mountain Grove, MON6687JRio Creek Aviators Ltd · Casco, WIN6687WHolland William A · Brownwood, TXN6687ZCrop Doctor Aviation Inc · Hill City, KSFirst renewal notice
Back to AD 81-18-04 R2