Skip to content

Registered aircraft · 8,138

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N1872TCarrow Marcus · Yorktown, INS/N 28-7125505 N1873JDonovan James L · Tarrytown, NYBuilt 1968 · S/N 28-24315 N1875JJohnson Kent F · Rancho Murieta, CABuilt 1968 · S/N 28-24317 N1879JDavidson Lucas · Green Springs, OHBuilt 1968 · S/N 28-24323 N1880TBongartz Christian J · Ramsey, MNBuilt 1971 · S/N 28-7225034 N1881JDavidson Pascal Carl · Savannah, GABuilt 1968 · S/N 28-24325 N1882TSonel Derya · Colorado Springs, COS/N 28-7225037 N1883JAnderson Dan Melvin · Salina, UTBuilt 1968 · S/N 28-24327 N1883TWilkins Joseph K · O Fallon, MOBuilt 1971 · S/N 28-7225038 N1885JGem Aviation Corp · Sugar Land, TXBuilt 1968 · S/N 28-24329 N1886JJones Freddy D · Amsterdam, OHBuilt 1968 · S/N 28-24330 N1886TKoester Deborah J · Courtland, MNBuilt 1971 · S/N 28-7225020 N1887TCulver Investments LLC · Gordon, TXBuilt 1971 · S/N 28-7225033 N1889HPlotnick Daniel G · Foxborough, MABuilt 1977 · S/N 28-7725166 N1889JBrain James E Jr · Rogers, ARBuilt 1968 · S/N 28-24334 N1892TB&R Aircraft LLC · Wadsworth, OHBuilt 1971 · S/N 28-7225042 N1894TIrish Dennis W · Erie, PABuilt 1971 · S/N 28-7225023 N1895JMellowship Stuart R · Zionsville, PABuilt 1968 · S/N 28-24340 N1896JWestern Edge Aviation LLC · Dickinson, NDBuilt 1968 · S/N 28-24342 N1897JGrimes Joseph Daniel · Kennewick, WABuilt 1968 · S/N 28-24343 N1897TMortgage Experts LLC · Homestead, FLBuilt 1971 · S/N 28-7225046 N1898JNorris Joseph M · Palatka, FLBuilt 1968 · S/N 28-24344 N18MUHobgood Mitchell D · Tylertown, MSS/N 28-3561 N18SWShannon Kenneth J · Cleveland, TXBuilt 1973 · S/N 28-7425049 N1909UBranch Stephanie B · Papillion, NEBuilt 1974 · S/N 28-7425215 N1910TBrown James E · Wind Lake, WIBuilt 1971 · S/N 28-7125464 N1911TSnp Aviation LLC · Avoca, IABuilt 1971 · S/N 28-7125412 N1911VLefort Charles J · Redding, CABuilt 1974 · S/N 28-7405103 N1913TWilliams Ronald P · Woodway, TXBuilt 1971 · S/N 28-7125474 N1923HGardner Christopher M · Mankato, MNBuilt 1977 · S/N 28-7725168 N1924HSkyjiro Forge Corp · Arcadia, CABuilt 1977 · S/N 28-7725169 N192FCFleming Michael D · Huntersville, NCBuilt 1968 · S/N 28-24374 N1930TWing John · Fort Worth, TXS/N 28-7125442 N1933HBlock Andrea · Chandler, AZS/N 28-7725170 N1933TLogan Flyers LLC · Logan, OHBuilt 1971 · S/N 28-7105151 N1935TWebboe Investments LLC · Falls Church, VABuilt 1971 · S/N 287105153 N1936SMoore Christopher D · Cheyenne, OKBuilt 1964 · S/N 28-3173 N1936TN1936t LLC · Franklin Park, NJBuilt 1971 · S/N 28-7105154 N1937TChristianson Eric L · Peoria, AZBuilt 1971 · S/N 28-7125490 N193WMCarter Jason W · Owens Cross Roads, ALBuilt 1970 · S/N 28-5795 N1942TGullion Monte C · Scottsburg, INBuilt 1971 · S/N 28-7105155 N1942ZThird Step 5 LLC · Gilbert, AZS/N 28-22849 N1943TFuhrman Ronald A · Fargo, NDBuilt 1971 · S/N 28-7105156 N1944TBeen Flying LLC · Colchester, CTBuilt 1971 · S/N 28-7125497 N1945TPatterson John W · Stockton, CABuilt 1971 · S/N 28-7125506 N1948TAshely Jane E · Midlothian, TXS/N 28-7125451 N194RJSmith Collin C · Bakersfield, CABuilt 1966 · S/N 28-2760 N1953TDaniella Levi & Associates Pc · Fresh Meadows, NYBuilt 1971 · S/N 28-7105190 N1954TDmac Aircraft LLC · Savannah, GABuilt 1971 · S/N 28-7105191 N1962TPinnacle Plane Company LLC · Aberdeen, NCS/N 28-7105196

Back to AD 96-10-01 R1