AD 90-04-06 R1
Registered aircraft · 68,369
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.
N110TNMaloney Casey · Placerville, CAN110VPFly Aviation Corp · Wilmington, DEN110WWTorba Jacob · Citrus Heights, CAN11103Hennigan Shellie · Jonesboro, LAN1110ERegistration Pending · Hanford, CARegistration pendingN1110FSallade William L · Coudersport, PAN11115Crist Steve · Reno, NVN1111AKnutson Wayne R · Tioga, NDN1111EDory Joe · Austin, NVN1111HBielamowicz John Kolbe · Waxahachie, TXN1111LShepard Logan K · Sultan, WAN1112ABallek Jeffery A · North Pole, AKN1112XArrow Flyers LLC · Englewood, CON11132Triple One 32 LLC · Sergeant Bluff, IAN1113CBrown Daniel A · Gettysburg, PAN1113NSkywagon Aero LLC · Wilmington, DEN1113ULeft Base Aviation LLC · Niagara, WIN1114EGetz Darrel P · Colfax, WAN1114LTriple One Four Lima Express LLC · Groton, CTN1114RUnavex Corp · Pensacola, FLN1114VEaa Aviation Foundation Inc · Oshkosh, WIN11153Pleasant Aviation LLC · Mount Pleasant, TXN1115FSilverhawk Aviation Academy LLC · Caldwell, IDN1115JJordan Jonathan D · Twin Falls, IDN1115UAvian Leasing LLC · Bremerton, WAN11168Sharp Frank J · Orlando, FLN1116ESkyhawk Aviation LLC · Albuquerque, NMN1116LR J Berra Inc · Burtonsville, MDN1116PSale Reported · Scottsville, VASale reportedN11170Weeks Kermit A · Polk City, FLN11172Skaaire Society · Madison, WIN11178Leahy Thomas J · Lksid Marblhd, OHN1117CWommack Leland E · Lone Star, TXN1117ELocke Mason · Cloudcroft, NMN1117HSenf Raymond L · Central Square, NYN1117RSchmidt Gail · Florence, CON1117UBhp Aviation · Santa Clara, CAN1117XHarshman James M · Washington, PAN1118AKing Charles W · Kelseyville, CAN1118HNelson Chester C · Little Falls, MNN1118MBrown Brent R · Edmond, OKN1118NJets To Helis LLC DBA · Chandler, AZN1118QAscend Aviation LLC · Bountiful, UTN1118XKdr Avgroup LLC · Wilmington, DEN1118ZMoorhouse Mark A · Santa Fe, TNN1119AGross Steven B · Rockville, MDN1119ECole Jack A · Sun City West, AZN1119RBochsler Mark J · Brush Prairie, WAN111AQualitair LLC Trustee · MichelstadtN111AEMatthews Timothy I · Belvidere, NJ
Back to AD 90-04-06 R1