Registered aircraft · 108,433

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.

N2461GSeven Hi Flying Club · Saratoga, CABuilt 1959 · S/N 51761 N2461PMaxxum Financial Group Inc · Destrehan, LABuilt 2005 · S/N 172S10044 N2461QJessi Air Ltd · West Salem, OHBuilt 1977 · S/N 28-7790399 N2461RFx Mining LLC · Haines, AKBuilt 1964 · S/N 18255561 N2461XBallard Devin J · Quail, TXBuilt 1965 · S/N 18256361 N24625Mason Ron · Tallahassee, FLBuilt 1972 · S/N MC-140 N24629Hurd Jeffrey R · Gilbert, AZS/N M-1458 N2462EFive Six Zero One LLC · Orange, CABuilt 1978 · S/N 17271291 N2462GWinged Vision Inc · Gaithersburg, MDBuilt 2007 · S/N 20608296 N2462PSan Diego Aviation LLC · San Diego, CABuilt 2005 · S/N 18281733 N2462RTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1969 · S/N 28-5628 N24631San Jose Mixer Inc · Gilroy, CABuilt 1973 · S/N M-1459 N2463BMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2005 · S/N 18281735 N2463PCox Christopher · Flovilla, GABuilt 1955 · S/N 22-2838 N2463SNjnj Aviation LLC · Belmont, CABuilt 2005 · S/N 18281738 N2463TEveland Marty M · Lake Geneva, WIBuilt 1962 · S/N NAV-4-2463 N24640Olive Aviation LLC · Anchorage, AKBuilt 1973 · S/N M-1461 N24645Kangas Matthew W · Covington, WABuilt 1973 · S/N MB-564 N24646Kosko Stanley G · Seattle, WABuilt 1973 · S/N MB-561 N2464DAero Equities LLC · Ventura, CABuilt 2005 · S/N 172S10046 N2464HSo Cal Leasing LLC · El Cajon, CABuilt 2005 · S/N 172S10049 N2464PAdams Gregory L · Lake Stevens, WABuilt 1955 · S/N 22-2839 N2464QWilson Jeff · White Bluff, TNBuilt 1977 · S/N 28R-7737035 N2464RStoffers William · Samoa, CABuilt 1964 · S/N 18255564 N2464SShellabarger Edwin L · Anchorage, AKBuilt 1979 · S/N 18-7909150 N2464WOktela Steven L · Melbourne, FLS/N 3213093 N24652Graber Howard J · Montgomery, INBuilt 1973 · S/N M-1430 N24653Phillips Alan K · Junction City, ORBuilt 1973 · S/N MB-570 N2465CToal Timothy R · Milan, ILBuilt 1954 · S/N 30765 N2465ELeal Felipe · Missouri City, TXBuilt 1978 · S/N 17271292 N2465GMunson Darrel L · Ogallala, NEBuilt 1959 · S/N 51765 N2465RDarrow Brett · Minerva, NYS/N 28-5629 N2465TDenna David · Port Charlotte, FLBuilt 1962 · S/N NAV-4-2465 N2465UProtzair LLC · Aiken, SCBuilt 2005 · S/N 17281272 N2465XK4 Land And Grain Co · Lothair, MTBuilt 1965 · S/N 18256365 N24660Arey Dale W · Laramie, WYBuilt 1973 · S/N MB-565 N24662Dumay Chad · O Fallon, MOBuilt 1973 · S/N MC-139 N24663Stuber Paul A · Kansas City, MOS/N M-1425 N24665Axiom Development & Consulting LLC · Atlanta, GAS/N MC-147 N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293 N2466GIreland Jeffrey L · Shobonier, ILBuilt 2004 · S/N 1244 N2466HRaven Girl LLC · Eagle River, AKS/N 18-7909187 N2466PGriffin Scott M · Springfield, OHBuilt 1955 · S/N 22-2841 N2466QWentworth Douglas G · Simpsonville, KYBuilt 1966 · S/N 18257666 N2466RToland Beldon T · Dodge City, KSBuilt 1964 · S/N 18255566 N2466TSvetfur Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10062 N2466VD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 2005 · S/N 172S10063 N2466XSpengler Raymond F Jr · Longview, TXBuilt 2005 · S/N 172S10064 N24671Mustang Sally Aviation LLC · Signal Hill, CABuilt 2000 · S/N 17280925 N24672Gurgainous Larry K · Fredericksburg, VABuilt 1973 · S/N MC-154

Back to AD 2007-04-19 R1