AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N340RPMeister Scott R · Skillman, NJN340RRCustom Data Engineering Inc · Phoenix, AZN340RSWestermeyer Holdings LLC · Longville, MNN340SBStarlight Express LLC · Bellevue, WAN340SDRegistration Pending · Kaukauna, WIRegistration pending, canceledN340SGN340sg Leasing LLC · Sheridan, WYN340SHHenderson Scott · Tucson, AZN340SPAlbray Aviation LLC · San Antonio, TXN340STSchlabach 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, KSN340XXTaylor Christopher A · Phoenix, AZN340YDown The Line LLC · Newport Beach, CAN340YCBa Air LLC · Searcy, ARN340YPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN340YZN340yz Corp Trustee · Wilmington, DEN3411BRedstone Ventures LLC · Sun Prairie, WIN3419JBlackhawk Air LLC · La Porte City, IAN341ATKlodd Stephen · Granbury, TXN341BCAbeflies LLC · Montvale, NJN341BGAttack Jack Enterprises LLC · Wilmington, DEN341CMBc Aviation · Perham, MNN341EYEdy Aviation LLC · Framingham, MAN341HCStc Aviation Inc · Saint Cloud, MNN341JPRed Arrow Leasing Inc · Paw Paw, MIN341MTI2i Logistics LLC · Wheeling, ILN341PSWestern States Air LLC · Phoenix, AZN341SCShedd Aviation LLC · Columbus, INN341SJAga Aviation LLC · Lewes, DE
Back to AD 2012-10-13