AD 94-05-05 R1
Registered aircraft · 26,231
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-05-05-R1')
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-05-05-R1')
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-05-05-R1') 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-05-05-R1') 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.
N1874NCuddie Robert R · Marble Falls, TXN1874VRaczynski Adam · Far Rockaway, NYN1874YCouncil Melvin · Squaw Valley, CAN1875BWilliams William O · Oswego, ILN1875VTigger LLC · Missoula, MTN1875YBrotheridge Bryan R · Merritt Island, FLN1876CRichardson Todd G · Olalla, WAN1877NAscolese Michael J · Athol, MAN1877VHickman Robert J · Canby, ORN1878BSneed Dana L · Kilgore, TXN1878PLutter Jim L · Gann Valley, SDN1879BPoint Jeffrey M · Mukwonago, WIN1879CWallick Philip L · Chico, CAN1879VAnderson Marshall C · Jacobson, MNN187DCPeterson Arthur L · Menifee, CAN187ERMustang Sally Aviation LLC · Camden, SCN187MRegistered aircraftN1880KObrien William D · Duluth, MNN1881CAmaryllis Living LLC · Tampa, FLN1881VSimonson Todd D · Minnetonka, MNN1881YSutton Aircraft Salvage LLC · Palmer, AKN1882VBell William F · Peachtree Corners, GAN1882YDunlap Alexander W · Eads, TNN1883KBolton Derwin B · Jacksonville, TXN1883NStrand Stephen E · Pelican Rapids, MNN1885BN1885b LLC · Birch Run, MIN1885CZibell David H · Olympia, WAN1887CRiggs Eugene D · Shoreline, WAN1888CWayman Ian A · Peyton, CON1888NMorton William J · Hurst, TXN1888VMiller Thomas Lee · Clemmons, NCN1889CKlindworth Bo N · Beulah, NDN188CRempfer David Dwayne · Chandler, AZN188ERegistration Pending · Haskell, OKRegistration pendingN1890NVasquez Allison O · San Antonio, TXN1891CCoetzee Theo · San Luis Obispo, CAN1891NMcmaster James R II · Bath, PAN1891YCarolina Sky LLC · Rock Hill, SCN1892YBaker David Laurence · Nelson, WIN1893CFife Christopher R · Winslow, MEN1893YWhelan John J · Mount Vision, NYN1894BHaynes Elton E · Palestine, TXN1894NWarren C Metzger II · Anchorage, AKN1894VKohlert Jeffrey R · Saint Charles, ILN1895VMontgomery Larry G · Seymour, INFirst renewal noticeN1896CGladish Jeffrey · Terrell, TXN1896YArmond Richard Joseph · Thousand Oaks, CAN1897BSherrod Robert W Jr · Burleson, TXN1897CBentley Eric T · Farmersville, TXN1897NNasw Foundation · Rio Grande, NJ
Back to AD 94-05-05 R1