AD 94-05-05 R1
Registered aircraft · 26,230
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.
N8381TMapes Peter B · Oscoda, MIN8381UFuryious Aviation LLC · Bossier City, LAN83822Christmann James C Trustee · Santa Cruz, CAN8382GArneson Kenneth W · Beaverton, ORN8382JHouseknecht Thomas · State College, PAN8383BSpears Franklin L · Lebanon, KYN8383MKessler Aviation LLC · Lansing, WVN8383UBuzby Justin T · Wasilla, AKN83845Johnson Walter R · Chuckey, TNN8384GWoodall Steve W · Penngrove, CAN8384JKondol Andrlej J · Maspeth, NYN8384M1st Clev-Mar LLC · Gainesville, TXN8384XVehrs Roger K · Roseburg, ORN8385BTkn Holdings LLC · Pima, AZN8385JJones Stanley E · Vallejo, CAN8385UClow Streeter M · Mansfield, OHFirst renewal noticeN8386ATwo Flyers LLC · Wilmington, DEN8386GIndy Hot Air LLC · Westfield, INN8386JMyers Raymond R · Deer Park, WAN8386XSchool Board Of Leon County Florida · Tallahassee, FLN8387GAir Land And Sea Adventures LLC · West Palm Beach, FLN8387URegistered aircraftN83883Snell Gary A · Dresden, MEN8388BTouch And Go Inc · Center, CON8388JCunningham Kevin M · Alexandria, MNN8389MTechnical Education Services Inc T/A · Virginia Beach, VAN8389TSchupman Joseph M III · Elk, WAN838HPKeathley Jeremie L · Rolla, MON8390THartmann Erich · Puyallup, WAN8390XMoore Laura D · Sacramento, CAN83919Mcgrath Robert J · Greensboro, NCN8391GReynolds Timothy D · Locust Grove, GAN8391JDaily Joshua J · Rochester, WAN8391TRolling Robert A · Oklahoma City, OKN8391XAmerican Aviation Inc · North Wilkesboro, NCN83927Denormandie Jacob J · South Paris, MEN8392BWeber Thomas P · North Bend, WAN8392GSander Clay O · Mutual, OKN8392URegistered aircraftN83937Edwards David E · Mount Olive, NCN8393BSingh Gurdev · Cathedral City, CAN8393MPatterson Robert A · Hillsboro, ORN8393UMadsen Christian A · Hilton Head Island, SCN83948Dick James D II · Centerville, TNN8394TBurke Dennis E · Hermiston, ORN8394XBates Dale R · Cincinnatus, NYN8395BHughston Chris · Nashville, TNN8395GSmith David B · Indianapolis, INN8395MJuliet Foxtrot Aviation LLC · Camden, SCN8395XAccurate Aviation LLC · Spring City, UT
Back to AD 94-05-05 R1