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.
N5546DKennedy Kevin L · Moscow, IDFirst renewal noticeN5546FCe-1382 LLC · Point Clear, ALN5546HMoore Thomas P · Basalt, CON5546JRegistration Pending · Danbury, CTRegistration pendingN5546KRegistration Pending · Port Saint Lucie, FLRegistration pendingN5546MMathias Mark R · Gnadenhutten, OHN5546PMowinski Frank R Jr · Ray, MIN5546QBrant Ryan L · Meyersdale, PAN5546RGorn Joel · Lawrence, MAN5546SChoice Vc LLC · Oakland, MIN5546UWright Michael R · Bristol, FLN5546WThird Step 4 LLC · Gilbert, AZN5546ZKooima John C · Rock Valley, IAN55470Ebersole Wayne D · Fairfield, MTN5547JWinds Aloft LLC · Huntsville, ALN5547QMooney N5547q LLC · Sacramento, CAN5547VDahl Demar · Deeth, NVN55482Crook Mark E · Elberton, GAN55483Edisto LLC · Falls City, NEN55484Yoder Sylvan R · Camilla, GAN55485Cross Gary DBA · Commerce Twp, MIN5548CBme&G Enterprises LLC · State College, PAN5548DKirkpatrick Robert · Placerville, CAN5548FMueller Albert · Brookfield, WIN5548HYoungs Erin M · Gillette, WYN5548QKlassic Rides LLC · Newton, NCN5548SGardner Timothy J · Gardnerville, NVN5548UMorales Ramos Abdiel · Tucson, AZN55497Murphy David B · Germantown, MDN55498Burke Monte D · Dallas, TXN5549AGeoterra Inc · Eugene, ORN5549DRobert T Parker Jr · Bigfork, MTN5549JLombardi Steven · Edgewood, TXN5549NRfd Aero LLC · Wilsonville, ORN5549UFar From Cheap LLC · Wichita Falls, TXN5549WFons Wlliam M · Oconomowoc, WIN554CLLacy Clay · Groveland, CAN554CTGeyer Martin J · Caro, MIN554DDale Wes · Gainesville, GAN554DDMhr Holdings LLC · Indian Hills, CON554DKRvest Management LLC · Boulder City, NVN554EREmbry-Riddle Aeronautical University Inc · Prescott, AZN554FLTomenyaero Inc · Florence, ORN554GLConcho Aviation LLC · Sterling City, TXN554HSouthworth Elizabeth A · Igo, CAN554JCCouch Kent E · Bend, ORN554JFRhoton Joel S · Borger, TXN554JSKilo Kilo Mike LLC · Jacksonville, FLN554KCaux Brisebois Vincent · Newcastle, WAN554LBSons Family Enterprises LLC · Wichita Falls, TX
Back to AD 2007-04-19 R1