AD 83-14-07 R3
Registered aircraft · 40
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:83-14-07-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-14-07-R3')
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:83-14-07-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-14-07-R3') 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.
N1111KBlue Monkey Disposing & Recycling Inc · Tampa, FLN111DZDelta Hotel LLC · Griffin, GAN1225Fox R Bruce · Kennesaw, GAN12NWSodeog LLC · Plantation, FLN144SJTrigger Down LLC · Virginia Beach, VAN19BROttopilot LLC · Lewes, DEN250SRm Av-Med Consulting LLC · Baton Rouge, LAN28BPHvs Enterprises LLC · Durango, CON338NEldor Industries Inc · Toledo, OHN3635ACaljet Inc · Van Nuys, CAN3AGManaged Aviation Inc · The Villages, FLN419BCVagabond LLC · Baton Rouge, LAN440BANo More Jump Seats LLC · Bowling Green, KYN473TDManaged Aviation Inc · The Villages, FLN51EPEsa Montana LLC · Boulder, CON555PXWindsock Holdings LLC · Amarillo, TXN600BAJacks Express LLC · Wilmington, DEN601NGBullard Aviation Services Inc · Ormond Beach, FLN601PSchmidt Richard E · Fort Myers, FLN602PAYagen Gerald · Virginia Beach, VAN602WKStrange River Inc · Dripping Springs, TXN611EFCentral Air Service Inc · Lewistown, MTN62DGShiloh Air LLC · Spokane, WAN64715Yardley Management Ltd · Johnstown, PAN64717Top Aviation Services Inc · Weston, FLN65966Registered aircraftN68980Connected Aviation LLC · Peoria, ILN6898WSarah Business LLC · Wilmington, DEN6899RDavenport Henry B IV · Berryville, VAN6900TAircraft Guaranty Corp Trustee · Oklahoma City, OKN6903RFusion Marine Inc · Stuart, FLN69LPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN700EEMatteo Properties Inc · Wickliffe, OHN700TEAustin Bill DBA · Sparta, TNN702GPUniversal Investors LLC · Independence Chate, MIN728RTBurnside Jack · Rockwall, TXN77FPRegistration Pending · New Richmond, WIRegistration pendingN83WDJones Jamie M · Grants Pass, ORN858CHTriple Nickel Inc · Muleshoe, TXN86AT86at LLC · Elizabethtown, PA
Back to AD 83-14-07 R3