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.
N3371RRs Helicopters Inc · Winter Haven, FLN3371TSale Reported · Sanderson, TXSale reported, pending cancellationN3371YChavers Finley L · Newnan, GAN33727Cohran Chuck Earl · Bowdon, GAN33728Howard Andrew · Chillicothe, OHN3372DWings Like Eagles Aviation LLC · Newnan, GAN3372FSwanner Robert Craig II · Water Valley, MSN3372MFarah Michael J · Mclean, VAN3372SBmf Services USA LLC · Satellite Beach, FLN3372ULeading Edge Operations LLC · Knoxville, TNN3372XLeahy David J · Delaware, OHN3372ZPhilbrick Stephen C · Oquossoc, MEFirst renewal noticeN33733Swink Cory A · Gold Hill, NCN33735Mcenaney John E · Orlando, FLN3373DCarpenter Marshall Owen · Isanti, MNN3373LHowell Nicholas A · Englewood, CON3373RSkylane N3373r LLC · Rancho Cucamonga, CAN3373SWestern Metal Products LLC · Ellensburg, WAN3373URms Industrial Sales LLC · Neenah, WIN33745Hunt Joel P · Berlin, WIN33746Lynch Ryan · Gilroy, CAN3374DScootair LLC · Alburgh, VTN3374LLewallen William J · Eloy, AZN3374M74 Mike LLC · Ft Mitchell, KYN3374SCcf Ventures Inc · Bangor, MEN3374TLazy Eight LLC · Kalispell, MTN3374UMurphy & Son Construction Inc · Brownsville, VTN3374WMcfadyen Joseph P · Florence, SCN3374XLee Rollin Kim · Panaca, NVN3374YRegistered aircraftN3374ZKing Paul E · Albany, ORN33750Geek Air LLC · Wilmington, NCN33754Pietsch Aircraft Restoration And Repair Inc · Minot, NDN33755Stearns Patricia M · Pooler, GAN33759Flight Time Club LLC · Searcy, ARFirst renewal noticeN3375DQualls Randy J · Claremore, OKN3375FKintner William R · Port Angeles, WAN3375LRowan William · New Fairfield, CTN3375RRoyellair LLC · Stone Mountain, GAN33762Wits-Sims LLC · Canal Winchester, OHN33763Elon Aviation LLC · Burlington, NCN33764Ps Aviation Inc · Granada, MNN3376DHammond James F · Yellow Springs, OHN3376GLindsay Aviation Inc · West Seneca, NYN3376RStumm Robert W · Cadott, WIN3376XVanmeter Investments LLC · Tecumseh, OKN3376YFly Greater Breezewood LLC · Clearville, PAN33770Bassett Christopher D · Robbinsville, NCN33772Land Of Lincoln Flying Club Inc · Mattoon, ILN3377PFlying High LLC · Gore, VA
Back to AD 2007-04-19 R1