AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N434DKOshaughnessy Terrence · Boulder City, NVN434DMSmith Lester C Jr · Colleyville, TXN434DSFranseen Steven R · Northglenn, CON434DTTiffany David J · Lyme, CTN434DVClassic Management Of Lafayette LLC · Youngsville, LAN434FLPerkins Jeffrey E · Grand Prairie, TXN434JGGordon Adam Leo · Oakdale, LAN434JHCloud 9 Wings LLC · Webberville, MIN434JRMentor Holdings LLC · Columbia, MDN434JVClark Nathaniel T · Duncanville, TXN434LQualitair LLC Trustee · MichelstadtN434MGAviation Trust Company LLC · Oklahoma City, OKN434PABird Acquisition LLC · Phoenix, AZN434PWRivers Shannon V · Chesterfield, SCN434RBBrown Brian M · Downey, CAN434RJCantarino Ronald De Souza · Saugus, MAN434RSWestfall Brent J · Three Lakes, WIN434RVRudolph Richard W · Fort Worth, TXN434SPittsburg Flyers LLC · Pittsburg, KSN434SPLlp Leasing Group LLC · Lewes, DEN434TBFlightworks LLC · Crozet, VAN434WPZimmerman Justin W · Palmer, AKN43507Washington Joseph D · Springfield, ILN4350HKieser Investments LLC · Bloomington, ILN4350RB2 West Corp · Winona, MNN4350TAlexander Andrew P · St Pete Beach, FLN4350USchriber Dennis E · Danville, CAN4350WHochbrueckner Timothy W · Mineola, NYN4350ZBenning Gary R · Blue Grass, IAN43511Freedom Development Corporation LLC · Rock Hill, SCN43519Paris Air Inc · Vero Beach, FLN4351DSaldarriaga Oscar A · Simi Valley, CAN4351KBaumgartner Trucking Inc · Lafayette, INN4351QJohnson James Benjamin · Rosharon, TXN4351RVertol Systems Co Inc · Destin, FLN4351UHosteter Aviation LLC · Gentry, ARN4351XGoodwin 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, FLN4353JStevens Fredric Dale · Tucson, AZN4353LSummit Flight Academy LLC · Peculiar, MON4353QHaley Paul M · Hillsboro, NHN4353TJones Charles E Jr · Cottonwood, CA
Back to AD 2007-04-19 R1