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.

N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034 N1080STacoma Management Inc · Martinsville, VABuilt 1997 · S/N TH-1818 N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231 N1080WParks Robert Steven · Hayward, CAFirst renewal noticeBuilt 1973 · S/N CE-435 N1080XFlying With Fitch LLC · Porter, TXS/N 28-7525278 N10816Van Der Merwe Coenraad · Traverse City, MIBuilt 1968 · S/N 244753 N1081JSoto Osvaldo · Myersville, MDBuilt 1973 · S/N 81 N1081YWc LLC · Austin, TXBuilt 1996 · S/N E-3039 N1082FWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17272950 N1082PGarrett James D Jr Trustee · Coolidge, AZBuilt 1968 · S/N 18258855 N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207 N1082ZJohnson Henry D · Buena Park, CABuilt 1976 · S/N AA5B0346 N1083EDavis Gregory P · Olathe, KSBuilt 1977 · S/N 307-77 N1083LBenson Mark D · San Diego, CABuilt 1996 · S/N 24-3393 N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083 N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453 N1083WAeolus Aircraft LLC · Seminole, OKS/N TH-323 N10842Cranor Douglas R · Valdez, AKBuilt 1951 · S/N 18-671 N1084FSiktberg Timothy J · Nashville, TNFirst renewal noticeBuilt 1975 · S/N 18502739 N1084PTimothy Duane High · Glenwood, MOBuilt 2000 · S/N LIV-434 N10853St Johns Marine DBA · San Mateo, FLS/N 277854024 N1085FSale Reported · Greenwood, INSale reported, pending cancellationBuilt 1979 · S/N 17272951 N1085JFloyd Shea · Brownfield, TXBuilt 1973 · S/N 85 N1085MDuncan Terry C Trustee · Cupertino, CABuilt 1975 · S/N 18264221 N1086BState Of Alaska · Anchorage, AKBuilt 2024 · S/N 14698 N1086CTeare Matthew A · Sagamore Hills, OHBuilt 2003 · S/N 0462 N1086JRidgway Stephen · Avon, COBuilt 1973 · S/N 86 N1086LLade Burton G · Bemidji, MNBuilt 1959 · S/N 50564 N1086MSargent John E · Vancouver, WABuilt 1975 · S/N 18264222 N1086UHancock County Port & Harbor Commission · Kiln, MSBuilt 1976 · S/N 17266835 N1086WThomas R Cave Inc · San Jose, CABuilt 1996 · S/N EA-586 N1087CPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10268 N1087JKalivretakis Anthony · Southington, CTS/N 87 N1087SVolitation Ventures LLC · El Macero, CABuilt 1996 · S/N EA-587 N1088JDreiling Richard J · Ft Collins, COBuilt 1973 · S/N 110 N1088LLima Whiskey Ic LLC · Mertzon, TXBuilt 1995 · S/N E-2988 N1088UWestern Wyoming Aviation Services LLC · Pinedale, WYBuilt 1976 · S/N 17266837 N10897Edb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10606 N1089BDakota Territory Air Museum Inc · Minot, NDBuilt 1958 · S/N 1315 N1089CRegistered aircraftBuilt 1995 · S/N E-2989 N1089DHeavy Metal Air LLC · Farmingdale, NYBuilt 2006 · S/N 172S10269 N1089EAml Aviation LLC · Lexington, KYBuilt 1996 · S/N E-3030 N1089FWells Thomas J · Big Lake, AKBuilt 1975 · S/N 18502744 N1089JBradford Johnny E · Sacramento, CABuilt 1973 · S/N 111 N1089MPetersen Clayton · Albert Lea, MNBuilt 1975 · S/N 18264223 N1089PDetert Bradley · Valparaiso, INBuilt 1954 · S/N 23-98 N1089UJkg LLC · Murfreesboro, TNBuilt 1976 · S/N 17266838 N1089WKucera Christopher T · King George, VABuilt 1973 · S/N E-422 N1089XCoastal Aviation Partners LLC · Hubert, NCS/N 28R-7535236 N108AFRideout Melvin B Jr · Jarratt, VABuilt 2005 · S/N 10948

Back to AD 2007-04-19 R1