AD 2019-08-13
Registered aircraft · 1,554
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:2019-08-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:2019-08-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:2019-08-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:2019-08-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.
N222JMOld Well Aviation LLC · Charlotte, NCN222NFShelter Air Charter LLC · Brooklyn, NYN222TCCase Coal Sales LLC · Louisa, KYN222VRHp Transportation LLC · Phoenix, AZN222VVJbi Holding LLC · Madison, WIN223CFCbel Aviation Inc · Macon, GAN223JFJettair LLC · Dallas, TXN224CJEagle Aviation LLC · Hamel, MNN225DWGulf South Management Inc · Destin, FLN225SCRhode Jason · Austin, TXN22LXMarcelo Christian Demaria Inc · Dover, DEN22SDodson International Parts Inc · Rantoul, KSN232BWNoram Aviation LLC · Tulsa, OKN232HCTlhmrb LLC · Midway, FLN233TJCorsair Two LLC · Hillsboro, ORN237MPA7cj2 LLC · Greensboro, NCN238RMSacj LLC · San Antonio, TXN23BKBig Sky Leasing LLC · Madison, WIN23PSRfl Equipment LLC · Colorado Springs, CON23YTVision X LLC · Chattanooga, TNN241CJBeam 33 Inc · Billings, MTN2424JStratosphere Asset Management LLC · New Hampton, IAN242BSDm Aviation LLC · Lexington, SCN242KVEvv Air LLC · Missoula, MTN242LMHeritage Logistics LLC · Holdrege, NEN242PGPage Aviation LLC · Saint Louis, MON242RFOwsley Robert L · Anchorage, AKN242SDBinette Alan · Medford, ORN246ESFlight Services Inc · St Thomas, VIN246GLBonanza Management LLC · Newark, DEN247BGCornerstone Air LLC · Wilmington, DEN248KGJetnexa Two LLC · Gilbert, AZN248PMCourtney Inc · Irvine, CAN248RFStaff Air Group Inc Trustee · Wilmington, DEN248SEM7 Leasing LLC · Seattle, WAN249CALafayette Flight Service LLC · Broussard, LAN24HNLafayette Transit LLC · Danville, KYN24UGNorthern Jet Management Inc · Grand Rapids, MIN24XPOlive Organization LLC · El Paso, TXN251GMJrjgc Investments LLC · Saltillo, MSN251KDBusiness Aviation LLC · Springfield, MON252JKLow Country 525 LLC · Charleston, SCN252RVHssj LLC · Chattanooga, TNN253CWRegistered aircraftN256JBBlossman Gas Of North Carolina Inc · Swannanoa, NCN257HCartam Air LLC · San Antonio, TXN25BGSpearfish LLC · St Peters, MON25DLTextron Aviation Inc · Wichita, KSN25LZTvpx Trust Co LLC Trustee · North Salt Lake, UTN25PJPjs Aviation LLC · Dunn, NC
Back to AD 2019-08-13