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.
N4852GR&R Aero Services LLC · Eden Prairie, MNN4852LMohle Darren H · Carlsbad, CAN4852PGreenwood Auto LLC · Itta Bena, MSN4852TDeloach Stephen T · Brentwood, TNFirst renewal noticeN4852VR & R Aviation Services LLC · Darien, ILN4853Stoltz Michael A · Portland, ORN4853HHubbard David R · Dexter, MIN4853LSipos Henry A · Huntington Beach, CAN4853STurley Gregory D · Pell City, ALN4853ZPileggi James B · Berkeley, CAN48549Davies Richard E · Sequim, WAN4854GMilwaukee Aero LLC · Milwaukee, WIN4854JTrio Bravo Ltd · Hudson, OHN4854LBarnes Doyle W · Glen Carbon, ILN4854XGrundmeier Patrick B · Gilbert, AZN4855GWings Over Texas Holdings LLC · Denton, TXN4855LEagle Sky Patrol Inc · Deadwood, SDN4855TVaitai Rei LLC · Spring, TXN48568Spartan Education LLC · Tulsa, OKN4856AManning Travis J · Reno, NVN4856DOlsen Ernest D · Lino Lakes, MNN4856ERiggin Flight Service Inc · Madison, SDN4856GNatchez Flight Training LLC · Natchez, MSN4856LCraig Peter G · Sequim, WAN4856VColombie Michael A · Anchorage, AKN4856ZWason Luther M III · Raymond, NHN4857ARegistered aircraftN-number assigned, not yet registeredN4857GVero Technical Support Inc · Pensacola, FLN4857JWogan Ted E · Russellville, ALN4857LGlass Steven L · Knob Lick, KYN4857TWillis Donald H · Temple, TXN4857VNewsouth Aviation LLC · Auburn, ALN4857ZFrancis Harvey B · Key West, FLN48581Luis Enrique Quintana · Miami, FLN4858JSchapiro Stephen Alexander · Lambertville, NJN4858LSolis Moises G · Austin, TXN4858TGuerra Thomas C · Montgomery, TXN4859ADory Lakota L · Caldwell, IDN4859FRidgway Stephen · Avon, CON4859GAirgo Inc · Centralia, ILN4859LDavinci Ventures Inc · Bolingbrook, ILN4859NCollins Eric L · Poplar Grove, ILN4859TRamirez-Pagan Abelardo · Copperas Cove, TXN4859ZPinter John M · Grand Ledge, MIFirst renewal noticeN485AArcher Aircraft LLC · Wilmington, DEN485ABPrice Scott · Camas, WAN485BLBlue Line Aviation LLC · Smithfield, NCN485GRegistered aircraftN485GBVergon Keith E · Osceola, INN485JSPlaskett Mark G · King City, CA
Back to AD 90-04-06 R1