AD 96-18-13
Registered aircraft · 1,110
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:96-18-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:96-18-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:96-18-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:96-18-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.
N44RFKtpt Capital Holdings LLC · Hilton Head Island, SCN44VPGable S Corp · West Linn, ORN450KVTop Gun Air LLC · Pompano Beach, FLN450TJJaco Oil Co · Bakersfield, CAN451CKKalitta Charters LLC · Ypsilanti, MIN451CLCollins Aviation LLC · Sioux City, IAN451SJTexas Mna LLC · Westlake, TXN452CFHangar LLC · Las Vegas, NVN453AMN543am LLC · Englewood, CON454MFCpc Aviation LLC · Bellaire, TXN4554D&J Air LLC · Canyon, TXN455DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN455RCSolomon Mark Trustee · Wilmington, DEN457JAviation Leasing Group Inc · Wilmington, DEN458RMPjs Holdings LLC · Prior Lake, MNN45GDPacific Rim Management LLC · Middletown, DEN45HFBoard Of Regents Of The Univ Of Nebraska · Lincoln, NEN45KGAircraft Holding Solutions LLC · Newark, DEN45KNHawker800xp LLC · Dorado, PRN45LRN45lr LLC · Anchorage, AKN45NMTriple Crown Energy LLC · Tulsa, OKN45NPBgs Transport LLC · Wilmington, DEN45TUFlying Amici Aviation LLC · Owasso, OKN468ESAir Roc Group LLC · Canandaigua, NYN46MKSplendid Jet Lease LLC · Cape Coral, FLN474CFCarrousel Aviation LLC · Monroe, WIN475HMFalcon Double D 163 LLC · Fort Lauderdale, FLN478PAMerlin One Aircraft LLC · San Antonio, TXN479JSWest Lake Holdings Inc · Fort Smith, ARN47ANLagoinha Orlando Church Inc · Orlando, FLN47HAHoosier Jets LLC · Sellersburg, INN47RARoyal Air Freight Inc · Waterford, MIN480MEMe LLC · Scottsdale, AZN481NSJp Flying LLC · Dover, DEN489BMEd Santos & Associates LLC Trustee · Wilmington, DEN4950BBeaubouef Aviation LLC · Shreveport, LAN497SPClyde Air LLC · Boston, MAN498CSMmu-Cit-Aviation LLC · West Orange, NJN499GSN499gs LLC · Nashville, TNN49CTJog001inc · Lewes, DEN49GGGainesville Aircraft Sales Inc · Gainesville, FLN49HMFlying Bullet LLC · Grand Island, NEN49MNAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN49WLRfs Air LLC · Tucson, AZN4BAMonte Carlo Associates LLC · Santa Ana, CAN4EASaldana Air LLC · Huntley, ILN4QNLabutte LLC · Dearborn, MIN500BJAir Metro Leasing Inc · Wilmington, DEN500FRInterstellar Air LLC · Gainesville, FLN500JSTmfb Transportation LLC · Orlando, FL
Back to AD 96-18-13