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.
N4079DErnst Gregory R · Eagle Creek, ORN4079PN4079p LLC · Peoria, AZN4079XRichardson Scott · Grapevine, TXN4079ZNewton James K · Charles Town, WVN407AFRuff Brent M · Santa Clarita, CAN407BWBridgewater State University · Bridgewater, MAN407CBLanham Kelty R · Fresno, CAN407CDKelly George Sumner · Columbus, GAN407CVCivil Air Patrol · Maxwell Afb, ALN407DMPhillips Consulting Group Inc · Wilmington, DEN407EBAb Prop Plane II LLC · Metairie, LAN407FAStratus Rr LLC · New Castle, DEN407FDVilkin Peter D · Palo Alto, CAN407FRRich Carolyn A · Redondo Beach, CAN407FTSlipstream Inc · Cincinnati, OHN407JCPlane Partners LLC · Newton, MAN407MD9k Air LLC · Newark, DEN407MNMaldonado Leopoldo · Paramount, CAN407PCOversquare LLC · Norman, OKN407RKMoore John C · San Miguel, CAN407RSSiddens Tab D · Albany, MON407SGriffing Flying Service Inc · Port Clinton, OHN407SCAlpha Charlie Aviation LLC · Oregon City, ORN407TVolunteer Aerials LLC · Stanley, NCN407TLBas Part Sales LLC · Greeley, CON407WBBad Dog Aviation LLC · Wasilla, AKN407WYVerdoljak Corey · Homer, AKN407XCallahan Ashton G · Homer, AKN40801Island View Flying Club · Goleta, CAN40806Sky Dream Flight School LLC · Dallas, GAN4080DCrane Gary W · Gig Harbor, WAN4080SCosse John J Jr Trustee · Lenexa, KSN4080YPanama City Cycles Inc · Panama City, FLN4080ZVan Dyke Brian S · Rio Oso, CAN4081Pearl Equipment LLC · Bassfield, MSN40810Qualitair LLC Trustee · MichelstadtN40812Dae Aviation Enterprises Corp · Gilford, NHN4081DEarl Tim G · Plymouth, CAN4081EOrlando Aircraft Sales LLC · Orlando, FLN4081SScheerer Martin · Edina, MNN40823Ashley Aviatrix LLC · Atlanta, GAN40829Shively Ray F · Turtlepoint, PAN4082BJdj Inc · Mountain Home, ARN4082DSharp Nicholas · Valdez, AKN4082JEmerald City Aircraft Leasing Inc · Port Orchard, WAN4082RMid-Life Crisis Aviation LLC · Renton, WAN4082XLeach Joey D · Flat Rock, INN40830Spirit Of Rocky Mount LLC · Nashville, NCFirst renewal noticeN40836Hawkins Joshua L · Colbert, GAN40838Andrews Mark F · Jacksonville, FL
Back to AD 2007-04-19 R1