AD 94-04-13
Registered aircraft · 274
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:94-04-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:94-04-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:94-04-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:94-04-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.
N677JRRoach James M · West Bountiful, UTN67SSCalongne Klint · Cypress, TXN680FTTwin Aviation LLC · Natchitoches, LAN680PLDw Educational Research Inc · Fowler, CAN680RRNizex Inc · Jackson, GAN68113Gogoplex LLC · Wilmington, DEFirst renewal noticeN6819QWalker Gilbert R · Brentwood, TNN681SPD&K Harvesting Inc · Labelle, FLN681TCRockstar Air LLC · Waco, TXN6883SWebb Ronald G · Dickson, TNN690RRCentral Airlines Inc · Leawood, KSN698RTsi Disaster Recovery LLC · Melbourne, FLN69PTAerofix Structural Service LLC · Horn Lake, MSN70DMartin Ernest · Sandpoint, IDN711NECommander Flight Group LLC · Charlotte, NCN713SPCentral Airlines Inc · Leawood, KSN715LGGuy Transportation Ltd · Carolina, PRN716TCCentral Airlines Inc · Leawood, KSN730RFCommand Aero LLC · Chicago, ILN741CAHarold F Mowery · Mechanicsburg, PAN742WAirborne Holdings Inc · Midlothian, TXN747HSale Reported · Santa Rosa, CASale reportedN757DDBosco74 LLC · Wilmington, DEN75JRWillis James R · Belleview, FLN760VRSkyway II LLC · Naples, FLN777CMCentral Airlines Inc · Leawood, KSN777VMAbbing Frits G H · Crescent City, FLN78345Peter Claire Ltd · George TownN78379Bottrell John E II · Yukon, OKN787RKEpitrop Foundation · Wilmington, DENon-citizen corporation, flight hours not reportedN799CERed Oar Aviation LLC · Lookout Mountain, TNN7ACCommander Quest LLC · San Luis Obispo, CAN800ACTango Gulf LLC · Naples, FLN800TTwin Aviation LLC · Coushatta, LAN801DPSunset Aviation Services LLC · Coeur D Alene, IDN801KPlumlee James H · Bluffton, SCN811DKucheck Alan · Yucca Valley, CAN811PJObrien Neal J · Milton, GAN818TECentral Airlines Inc · Leawood, KSN8445CMaddox Jody S · Paterson, WAN8460CState Of Alaska Dept Of Fish & Game · Kodiak, AKN8468CIntravaia Anthony J · Mountain View, CAN8498CAir Margarita · San Juan, PRN8536Bosco74 LLC · Wilmington, DEN887BDBolin Industries · Hamburg, ARN8LXAerospace Trust Management LLC Trustee · Wilmington, DEN9011NSutton Aircraft Salvage LLC · Palmer, AKN9080NBoeing Co · Renton, WAN9096NStones River Aviation LLC · Murfreesboro, TNN90JPAec Shrike LLC · Barrington, IL
Back to AD 94-04-13