AD 2007-23-13
Registered aircraft · 597
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-23-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:2007-23-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:2007-23-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:2007-23-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.
N815CMAmerileasing Corp DBA · Cheyenne, WYN816SHSilverhawk Aviation Inc · Lincoln, NEN817EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN817SHTilt Up Travels LLC · Norfolk, NEN818BFStarlight Aviation LLC · Harvey, LAN818RUWorldwide Alliance Air LLC · Ocala, FLN818SHSilverhawk Aviation Inc · Lincoln, NEN819SHSilverhawk Aviation Inc · Lincoln, NEN823CBThunderbird Equipment LLC · Hillsboro Beach, FLN826ACTwin City Jets LLC · Wilmington, DEN830JBCalcutta Air LLC · Dover, DEN83EPRegistered aircraftN83HAFly My Ultra LLC · Sellersburg, INN83ZAOp Partner Inc · Odessa, TXN840AAD And S Western Holdings LLC · Garden City, TXN840CTKeith Hammett LLC · Missoula, MTN845ATApalach Adventures LLC · Chattanooga, TNN848GAdmin Holdings LLC · Colleyville, TXN850MACentral Aviation LLC · Sebring, FLN851SHFlight Time LLC · Des Moines, IAN852SHFive Stallions LLC · Valley, NEN853ACSwihart Properties LLC · Roanoke, INN853CRVehicle Holdings Inc · Las Cruces, NMN856ACVision Jet LLC · Fort Wayne, INN858MEFlying Turtles Two LLC · Dallas, TXN85EBGt Commercial Interests LLC · Austin, TXN860CRGulf Atlantic Airways Inc · Gainesville, FLN863JBPj One LLC · Land O Lakes, FLN868CWBig Sky Insulations Inc · Belgrade, MTN876JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN87SFSeneca Foods Corp · Penn Yan, NYN880PSVientos Air LLC · Santa Fe, NMN883TXWhitehorse LLC · Puyallup, WAN884RCJannenga Air LLC · Phoenix, AZN888GDCluheir LLC · Van, TXN891FVSuper King LLC · Wilmington, DEN891KSParr Aviation LLC · Demopolis, ALN899PEArkansas Jet Sales & Leasing LLC · Little Rock, ARN89MDFuturesource Capital Corp · Bismarck, NDN89PR603 Holdings LLC · Aberdeen, SDN900EN900e LLC · Lewes, DEN900PSAero Air Charter Holding LLC · Pensacola, FLN901ABAngel Brothers Enterprises Ltd · Baytown, TXN901LBNwl Capital Holdings LLC · Black Eagle, MTN904JJetran LLC · Horseshoe Bay, TXN904LRChrysler Aviation Inc · Van Nuys, CAN905LCLoraine LLC · Wilmington, DEN909DJCitation N909dj LLC · Palm Beach Gardens, FLN909LBNtbb LLC · Henderson, NVN910TKThompson Nathan · Boulder, CO
Back to AD 2007-23-13