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.

N1438USale Reported · Greeley, COSale reportedBuilt 1976 · S/N 17267105 N14395Eastern Stearman Inc Trustee · Leesburg, VABuilt 1974 · S/N 18-7409093 N1439JBeckler Scott · Omaha, NEBuilt 1976 · S/N 439 N1439UCass Aviation LLC · Henderson, NVBuilt 1976 · S/N 17267106 N1439XDovy Aviation LLC · Houston, TXBuilt 1975 · S/N 28-7525301 N143ABMisch Keith · Staten Island, NYS/N 29-0400 N143AMMcgee Ronald S · Las Vegas, NVBuilt 1997 · S/N 1081 N143BHTappan Holdings Inc · Cadiz, OHS/N 21003C N143BSMoses Charles · West Friendship, MDBuilt 1966 · S/N 28-3792 N143CCAerial Messages Leasing Co · Longwood, FLBuilt 2003 · S/N 9956CC N143CHHiers Craig L · Moultrie, GABuilt 1978 · S/N 3562 N143CPPonzo Christopher A · North Reading, MABuilt 1980 · S/N 18267699 N143CRNkm LLC · Glasgow, MTBuilt 1993 · S/N EA-550 N143DBBernard Daniel · GrillyBuilt 1965 · S/N 18256678 N143DROroca Flying Club LLC · Weehawken, NJBuilt 1972 · S/N 17261119 N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357 N143DVBruns Luke J · Flower Mound, TXBuilt 2007 · S/N 40026 N143EBLewis Thomas B · Granbury, TXBuilt 2007 · S/N 40307 N143EEFour Bs Montana Ranch LLC · Kalispel, MTBuilt 2014 · S/N 3218 N143EYTriple D Aviation LLC · Merritt Island, FLBuilt 1968 · S/N 28-24348 N143FCarlton John B · Lenoir, NCBuilt 1953 · S/N 23488 N143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290178 N143GLLiebert Glenn W · New Albany, OHBuilt 1996 · S/N LIEBERT 0001 N143HAHartman Dave · Miles City, MTBuilt 2021 · S/N 74318 N143HJHurlburt Ward B IV · Anchorage, AKBuilt 1976 · S/N 18503032 N143HPDans Aircraft Repair LLC · Gardiner, MTS/N NF0007 N143JDHarris Steven V · Springtown, TXFirst renewal noticeS/N 8083C N143JMMa Cedric Sek-Kong · Los Angeles, CABuilt 1964 · S/N 28-20358 N143KPescitelli Paul · Atlanta, GABuilt 1964 · S/N D-7664 N143KMBc Aircraft LLC · Edmonds, WABuilt 1977 · S/N 18265435 N143LKRobbins Larry K · La Follette, TNBuilt 1994 · S/N 190 N143LWMurphy Law Office Pc · Rapid City, SDBuilt 1979 · S/N R18201265 N143MBHughes Kathryn G · Council, IDBuilt 1963 · S/N CD-693 N143MGPatriot Air Inc · Maryland Heights, MOS/N 310K0134 N143MMPalo Michael Scott · Melbourne, FLBuilt 1970 · S/N 39-18 N143MYPeaks Rental LLC · Aurora, COBuilt 2004 · S/N 10478 N143PCFuqua Royce Owen · Early, TXBuilt 2004 · S/N 1379-2004 N143PDSouder James B · Port Orange, FLBuilt 1953 · S/N 53-4134 N143PROrtiz Ramon L · Teaneck, NJBuilt 1997 · S/N 22106 N143PSDrake Barbara A · Pensacola, FLBuilt 1986 · S/N 045 N143RMOft7 LLC · Ponca, ARBuilt 1975 · S/N 18263650 N143RNCollins Glen K Trustee · Appleton, NYBuilt 2012 · S/N 20385 N143RVLefevre Garrett R · Tucson, AZBuilt 1998 · S/N 22143 N143RWWendell Ross · Ankeny, IABuilt 2013 · S/N 40450 N143SDWhiskey Fox Group LLC · Destin, FLS/N 25005C N143SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4132 N143SWBb&D Airways LLC · N Redngtn Bch, FLS/N 310R1856 N143TBSmith Timothy T · Turkey, NCBuilt 1979 · S/N 28-8011053 N143TCHarris William D · Topeka, KSBuilt 1962 · S/N 205-0064 N143TMSchnautz Danny R · Pasadena, TXBuilt 2000 · S/N 29-0242

Back to AD 2007-04-19 R1