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.
N340SHHenderson Scott · Tucson, AZN340STSchlabach Herman · Belton, TXN340SUDm Air Ltd · Newark, OHN340SVQuetzal Aviation Corp · Washington, DCN340TARmb Leasing Inc · Dover, DEN340TBBerkshire Building Services Inc · South Egremont, MAN340TG340tg LLC · Elm Springs, ARN340THHinkle Anthony · Mineola, TXN340TLRegistration Pending · Henderson, NVRegistration pendingN340TSNighthawk Flight Systems Inc · Vista, CAN340TTPrecision Aviation LLC · Costa Mesa, CAN340UGonzalez Pablo II · Sweeny, TXN340UMSouthwest Management Group Inc · Farmington, NMN340VAMel Hambelton Ford Inc · Wichita, KSN340VLVanguard R&R Lease Co Inc · Dallas, TXN340VVYouth Aviation Academy · Roseville, CAN340WPraetorian Aviation Services LLC · Alva, FLN340WAFoshay Laird · Paso Robles, CAN340WDKnoxville Air Charter Service LLC · Strawberry Plains, TNN340WGBartlein & Co Inc · Santa Barbara, CAN340WHN340dg LLC · Spanish Fork, UTN340WJIntegritas Aviation LLC · Cedar Park, TXN340WMHarco Aviation LLC · Houston, TXN340WPNnk Holdings LLC · San Antonio, TXN340XCPrairie Aero LLC · Baldwin City, KSN340XLMoppert Robert C · Berryville, ARN340XXTaylor Christopher A · Phoenix, AZN340YDown The Line LLC · Newport Beach, CAN340YCBa Air LLC · Searcy, ARN340YPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN340YZN340yz Corp Trustee · Wilmington, DEN341Lurky Ilm LLC · Delco, NCN34101Aldrich Andrew J · Soulsbyville, CAN34102Jaquez Marlene D · Baton Rouge, LAN34104Mcgowan Glenn R · Poplar Grove, ILN34106Bellmann Carl W · Bryan, OHN34108Pierce Andrew · Littleton, NCN3410FMacy Richard H · Culver, ORN3410MArborio Peter J · Wethersfield, CTN3410NPedersen Bruce J · Sandpoint, IDN3410REpperly Scott C · Montague, CAN3410SDurtschi Jay W · Franklin, IDN3410TPeterson Barry · Sausalito, CAN3410UWegman Aviation LLC · Kenmore, NYN3411QSillinger Daniel E · Covington, LAN3411ROgp LLC · Wilmington, DEN3411SHorseshoe 182 LLC · Dickinson, NDN3411TSouthern Aero LLC · Theodore, ALN3411USutton Aircraft Salvage LLC · Palmer, AKN3411WAmerican Airpower Museum · Farmingdale, NY
Back to AD 2007-04-19 R1