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.
N4508XWestchester Flying Club Inc · Purchase, NYN4509HGolding Lee · Brookline, MON4509XPerformance Power Services Pc · Naperville, ILN4509YWolfrum John A · Two Rivers, AKN4509ZLawrence Bobby L · Willis, TXN450AACentex Aero LLC Trustee · San Antonio, TXN450BASimmons Brian R · Heavener, OKN450CACoast Flight Training And Management Inc · Dallas, TXN450EZBassen Gerald R · St George, UTN450FLMorriss Aviation LLC · Allen, TXN450JAHillsboro Aero Academy LLC · Hillsboro, ORN450PMStroede Scott E · King Salmon, AKN450RBurns Richard · Wasilla, AKN450RSMcpherson Norman B · Woodland Park, CON450VVCarver Aero LLC · Muscatine, IAN450ZRCasey William · Celina, TXN4510AGarvey James R · Fairhope, PAN4510DCamwhit Air Corp · Montgomery, NYN4510RMcmichael Steven G · Eden, NCN4510YFrost John David Trustee · Anchorage, AKN4510ZLamphere Michael T · Whitehall, NYN4511BGcbc LLC · Norman, OKN4511EN2893e LLC · Reno, NVN4511HVeritas Urbis Economics LLC · Groveland, CAN4511JNoyes Tony · Lewisville, TXN4511YWab Air LLC · Boulder, MTN4511ZKim Andrew · Upland, CAN45120Iowa Military Aviation Heritage Museum · Ankeny, IAN45121Wolff Reese · Chula Vista, CAN45128Bowker James K · Ponca City, OKN4512LA&J Aircraft Leasing Inc · Burlington, CON4512RElder Abuse Air Force · Rcho Sta Marg, CAN4512XSullivan Bradley · Tomball, TXN45134Last Chance Lance Auto Sales LLC · Ardmore, OKN45135Warren Jeremy D · Bloomington, INN4513DRkm Aviation LLC · Lexington, NCN4513FDeripaska Gary Stanley · Owasso, OKN4513JMalone Ronald · Englewood, TNN4513NRspp Group LLC · Friendswood, TXN4513RRegistration Pending · Fort Worth, TXRegistration pendingN45141T45141 LLC · Orange, CAN45146Isern Douglas J · Golden, CON4514AJones N Robert II · Indianapolis, INN4514BNiemann Professionals P A · Melbourne Beach, FLN4514FBy The Grace Of God LLC · Miami, FLN4514JTrinity Aviation Ltd · Wilmington, DEFirst renewal noticeN4514NAbc Flying Club Inc · West Mifflin, PAN4514VTorelli Bruce L · Memphis, TNN4515DTucker Gary · Youngsville, LAN4515HLindstrom Dale R · Kewanee, IL
Back to AD 90-04-06 R1