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.
N4349XElon Aviation LLC · Burlington, NCN4349YSpence Willard J · Davin, WVN434ABMondkar Avinash M · Payson, AZN434DDUtah State University · Logan, UTN434DRRichardson David · Sequim, WAN434DSFranseen Steven R · Northglenn, CON434DTTiffany David J · Lyme, CTN434FLPerkins Jeffrey E · Grand Prairie, TXN434JCClassy Cockpits LLC · Lino Lakes, MNN434JVClark Nathaniel T · Duncanville, TXN434PABird Acquisition LLC · Phoenix, AZN434RBBrown Brian M · Downey, CAN434RJCantarino Ronald De Souza · Saugus, MAN434RVRudolph Richard W · Fort Worth, TXN434SPittsburg Flyers LLC · Pittsburg, KSN434SPLlp Leasing Group LLC · Lewes, DEN434TAir Tebsin Twinbo LLC · Lewistown, MTN434WPZimmerman Justin W · Palmer, AKN43507Washington Joseph D · Springfield, ILN4350EUrgiles Carbaca Andres A · Lantana, FLN4350HKieser Investments LLC · Bloomington, ILN4350RB2 West Corp · Winona, MNN4350TAlexander Andrew P · St Pete Beach, FLN4350WHochbrueckner Timothy W · Mineola, NYN4350ZBenning Gary R · Blue Grass, IAN43511Freedom Development Corporation LLC · Rock Hill, SCN43519Paris Air Inc · Vero Beach, FLN4351QJohnson James Benjamin · Rosharon, TXN4351RVertol Systems Co Inc · Destin, FLN4351XGoodwin Austin M · Mesa, AZN43526Wittman Jeffrey A · Sonora, CAN4352ABrito Angelo M · Dillingham, AKN4352DAshdown Adrian · Canandaigua, NYN4352GBouza Mario · Santa Clara, CAN4352RQuad City Area Flying Eagles · Milan, ILN4352TJaycee Flying Club Inc · Mineral Ridge, OHN4352XBackstreet Aviation LLC · Hickory, NCN43530Pereira Jailton D · Elizabeth, NJN4353AVinson David L · Mc Alpin, FLN4353HMoore Jeffrey D · Blossvale, NYN4353JStevens Fredric Dale · Tucson, AZN4353LSummit Flight Academy LLC · Peculiar, MON4353QHaley Paul M · Hillsboro, NHN4353TJones Charles E Jr · Cottonwood, CAN4353VDiehl David S B Jr · Frederick, MDN4353XCharriez Jose L Jr · East Elmhurst, NYN43544Dibiaso Thomas F · Mount Laurel, NJN4354HLind Ronald C · Rainier, WAN4354PApache Twin Rental LLC · Harrisonville, MON4354THyldburg Aviation Inc · Plymouth, MA
Back to AD 90-04-06 R1