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.
N9511JGomez Alexandro · Riverside, CAN9511KMoore Matt R · Nashville, TNN9511MBenjamin Joseph · Erie, CON95121Preston Aviation LLC · Wilmington, DEN95122Mcnamara Kevin M Jr · East Aurora, NYN9512CDe Aviation Inc · La Porte, TXN9512DFerrell Alan B · Arlington, OHN9512FGeorge'S Aviation Services Inc · Honolulu, HIN9512HTracy Patrick J · Maddock, NDN9512JArapahoe Flight Club LLC · Colorado Springs, CON9512LKreykes K Douglas · Greeley, CON9512MBible Larry · Mount Pleasant, TXN9512SBlack Daniel L · Spicewood, TXN9512UWilkes Jack M · Port Orchard, WAN95133Rd Aire LLC · Opelika, ALN9513BLong Michael A · Grand Lake, CON9513CAgri Business Aviation Inc · Sparta, ILN9513HHigh Flight Academy LLC · Allison Park, PAN9513JGlorioso Richard · Plant City, FLN9513LMott Terry W · Hampton, IAN9513MHangar9llc · Queen Creek, AZN9513PAir Sailing Inc · Reno, NVN95147Ramirez Ricardo A · San Antonio, TXN9514DAdams David D · West Ossipee, NHN9514HFrerichs John E · Gurley, ALN9514JDu Bois Aviation Inc · Chino, CAN9514LBiller Mary Catherine · Columbus, OHN9514MHolen Benjamin E · Ketchum, IDN9514TColl Valdes Jeffrey A · Boise, IDN95151Gonzalez-Pinto Carmelo · San Antonio, TXN95154Cen Inc · Sheridan, WYN95157Smutek Brian D · Mio, MIN95159Kinne Dagmar · Woodburn, ORN9515BGrason Aviation LLC · Appleton, WIN9515DElmer Charles F · Saint Clair Shores, MIN9515JBowman Alex T · Virginia Beach, VAN9515KBoyd Matthew · Hudsonville, MIN9515MReid Stephen M · Gardner, KSN95160Registration Pending · Lakewood Ranch, FLRegistration pendingN9516FKelly David · Issaquah, WAN9516JEastern Kentucky University · Richmond, KYN9516KSmith Dalton L Trustee · Smyrna, DEN9516MBurrell John Eric · Springfield, VAN9516WRingco Aviation LLC · Oklahoma City, OKN95173First Flight Corporation · San Diego, CAN9517DLarson David R · Boerne, TXN9517FS Martinez Livestock Inc · Moxee, WAN9517JBanks Brian H · Zebulon, GAN95181Stahl Jason R · Etters, PAN9518DJaugust Vladimir · Somerville, MA
Back to AD 81-18-04 R2