AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N5613UAviation Trust Company LLC Trustee · Oklahoma City, OKN5613WHocking Terry G · Nashwauk, MNN5613ZAndersen Zachary J · Seward, AKN56140Lets Fly Az LLC · Scottsdale, AZN56141Simmerer Stephen J · Allenton, MIN56149Lets Fly LLC · Albemarle, NCN5614LFiler Jacob Adam · Clarksville, TNN5614QAltitude Aviation Services LLC · Mountain Home, IDN5614WColeman John H · Jackson, MIN56158Munyon William · Vineland, NJN5615LAnthonson Ronald G · Cortland, NYN5615QKhan Awad A · Clearwater, FLN5615WH&H Aviation LLC · Lehi, UTN5615ZKuebler Terry T · Gahanna, OHN56160Thatcher Michael · Delaware, OHN56161Ohmart Jeffrey A · Wichita, KSN5616EDhl Skyhawk Inc · Martinez, CAN5616YBigfoot Aviation LLC · Wilmington, DEN5617Roberts Andrew J · Brunswick, MEN5617JSale Reported · Wilton, CASale reportedN5617PBuchheit Dirk · Lake Worth, FLN5617QRegistration Pending · Perryton, TXRegistration pendingN5617UManagement Company Of South Carolina LLC · West Columbia, SCN5617WRose Dean R · Appleton, WIN56182Gerst Peter C · Williamsport, PAN5618QHecker Clark R · Flat Rock, NCN5618ZNull Clifford M · Punxsutawney, PAN56190Bertch Gary M · Waterloo, IAN56191Twedt Jeffrey Lee · Montrose, SDN56198Holden James R Jr · Milton, GAN5619ELiberty Flying Service LLC · Castroville, TXN5619HFranklin Vernon L · Aguila, AZN5619LEncarnacion Ramon A · Miramar, FLN5619WIsbell David Myles · Tucson, AZN561BLPiper Aircraft Inc · Vero Beach, FLN561DEFlynn John M · Martinez, CAN561FLOnwe Edward E · San Antonio, TXN561KEMaglaughlin Ronald D · Udall, KSFirst renewal noticeN561MAMcdonald Jeffrey D · Chilmark, MAN561MHDodson International Parts Inc · Rantoul, KSN561PWestern Farming LLC · Missoula, MTN561PUSkyborne Airline Academy Inc · Vero Beach, FLN561SCSpartan Education LLC · Tulsa, OKN561SDAugspurger David R · Seneca, SCN561SPIllinois State Police · Springfield, ILN561TFAir Fleet Holdings LLC · Missoula, MTN561TPKerner Christine A · Yelm, WAN561ZDelgado-Ocasio Brunilda · Patillas, PRN56201Kaney Howard W · West Bend, WIN56202Kunze Paul C · Tempe, AZ
Back to AD 90-04-06 R1