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.

N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710 N176PCCenterline Thrust LLC · Sarasota, FLBuilt 2005 · S/N 176 N176RKY-12 Investments LLC · Alexandria, VABuilt 2020 · S/N TH-2532 N176STCp A36 Inc · Knoxville, TNBuilt 1976 · S/N E-884 N176TAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2018 · S/N 172S12115 N176TCRedtail Cirrus LLC · Boise, IDBuilt 1979 · S/N 18503814 N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926 N176WHarwell Evin Dtrustee · Howell, MIBuilt 1978 · S/N E-1335 N176WBVincent David R · Hartley, TXBuilt 1976 · S/N 32-7600013 N176WWRegistered aircraftBuilt 2006 · S/N 2377 N176XClub Turbo 176 LLC · Santa Clara, CABuilt 1976 · S/N E868 N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383 N177Executive Travel Authority LLC · Wilmington, DEBuilt 1970 · S/N 27-4511 N17702Bosley Blake R · Richmond, TXBuilt 1977 · S/N CE-701 N17703Dakota Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N E-1007 N1770BScholz Francis M · Atchison, KSBuilt 1977 · S/N 150-739 N1770GJansen David C · Warm Springs, GABuilt 1962 · S/N TC-294 N1770RRegistered aircraftBuilt 1974 · S/N 18502490 N1770TCherryhill Aviation Inc · Freetown, INBuilt 1971 · S/N 28-7125385 N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791 N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998 N1771MGaley Matthew Blake · Greenwood, MSBuilt 1975 · S/N 18264433 N1771PHansen Larry G · Alliance, NEBuilt 1954 · S/N 22-2543 N1771SLange William H · Brandywine, MDBuilt 1999 · S/N 2060 N17722International Jets Inc · Gig Harbor, WABuilt 1977 · S/N TC-2045 N17726Air Commander LLC · Woodbury, MNBuilt 1977 · S/N TC-2046 N1772JCope Parrish B · Lemoore, CABuilt 1968 · S/N 28-24194 N1772WRichland Flight Academy LLC · Sidney, MTBuilt 1972 · S/N E-377 N17732Wright Brian L · Franklin, TNBuilt 1977 · S/N TE-1102 N17735Stoppelbein Colby · Kenansville, NCBuilt 1977 · S/N CE-703 N17738Lambert Michael C · San Jose, CABuilt 1977 · S/N CE-702 N1773BBaney Robert P · Philipsburg, PABuilt 1977 · S/N 17702730 N1773PWidman Ralph W · Lynchburg, OHBuilt 1954 · S/N 22-2545 N1773RAsher Robert P · Oregon City, ORBuilt 1978 · S/N R18200554 N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413 N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003 N17747Davis 180 LLC · Baton Rouge, LABuilt 1977 · S/N CE-704 N17748Montineri Joseph A · Port Orange, FLBuilt 1977 · S/N E-1017 N1774DDj Brandt LLC · Cedar City, UTS/N 17702028 N1774HPeacock Bruce M · Mendon, VTBuilt 1980 · S/N 18267507 N1774PBrandenburg Timothy C · Anchorage, AKBuilt 1954 · S/N 22-2547 N1774TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12111 N1774VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263747 N17751Brewer Bret D · Woodward, OKBuilt 1977 · S/N D-10004 N1775RAnderson Lenny R · King Salmon, AKBuilt 1974 · S/N 18502494 N17762Hightower Group Holdings LLC · Dallas, TXBuilt 1982 · S/N 28-8390023 N17763Kahanek Sylvester S · Deer Park, TXBuilt 1979 · S/N 28-8090179 N17764N17764 LLC · Quincy, WABuilt 1977 · S/N E-1021 N17766Elworthy Steven M · Huntington Beach, CABuilt 1977 · S/N E-1023 N17769Jmk Engineering Inc · Bloomfield Hills, MIBuilt 1977 · S/N E-1027

Back to AD 2007-04-19 R1