Registered aircraft · 108,428

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

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:2007-04-19-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:2007-04-19-R1') ORDER BY n_number

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041 N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1393FBenham John D · Blanco, TXBuilt 1975 · S/N 18502840 N1393PSeymour Lori L · Woodstock, GAS/N 23-445 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N1393VWayne Brett M · Saint George, UTS/N HAY 0001 N1393ZSdd LLC · Great Falls, MTBuilt 1961 · S/N D-6813 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1394JFendi Aviation LLC · Petal, MSS/N 394 N1394SGoodman Donald J · Bellingham, WABuilt 1976 · S/N 18264955 N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672 N13951Black Timber Aviation LLC · Rifle, COBuilt 1972 · S/N 18-8981 N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984 N1395FMoquin Christopher · Chicago, ILS/N 578 38 8392 N1395JWard Brian S · Long Beach, CABuilt 1975 · S/N 395 N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795 N1395SGarcia Robert W · Floresville, TXFirst renewal noticeS/N 18264956 N1395TLegacy Aerospace Industries LLC · Miami, FLS/N 28R-7235277 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673 N13960John Mark Air Repair LLC · Chugiak, AKBuilt 1972 · S/N 18-8984 N13966Chesapeake Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1970 · S/N 27-4581 N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012 N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796 N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674 N13973Rs Specialties LLC · Anchorage, AKBuilt 1972 · S/N 18-8985 N13974Total Prf LLC · New Smyrna Beach, FLBuilt 2006 · S/N 172S10409 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675 N1397ZJ&W Air LLC · Asheville, NCBuilt 1961 · S/N D-6819 N13986Euro 2000 Inc · Merritt Island, FLBuilt 2008 · S/N 17281503 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1398HMiller Debra L · Anchorage, AKS/N 15AC-449 N1398JPrivedenynk Sergey · Springfield, MABuilt 1975 · S/N 398 N1398PWolbert Valerie M · Canton, GABuilt 1956 · S/N 23-449 N1398RHopland Steven R · Johnson City, TNBuilt 1975 · S/N AA5-0798 N1398SOff The Charts LLC · Kalispell, MTBuilt 1976 · S/N 18264959 N1399MRegistered aircraftBuilt 1975 · S/N 18264314 N1399TLauff Samuel Jr · Ocala, FLBuilt 1972 · S/N 28R-7235278 N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070 N139AAMeloan Andrew Newton · St Helena Is, SCBuilt 2000 · S/N 04980085 N139ACDavis Mark A · Lubbock, TXBuilt 1992 · S/N 686-92 N139AGSchool Board Of Seminole Co Florida · Sanford, FLFirst renewal noticeBuilt 1981 · S/N 0131 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712

Back to AD 2007-04-19 R1