Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N1840Q6 Cs Air Inc · Tacoma, WABuilt 1971 · S/N 177RG0240 N1840VUnited States Air Force Owner · Apo, APBuilt 1974 · S/N 17263767 N1841QEvolution Electronics LLC · Superior, WIBuilt 1972 · S/N 177RG0241 N1842GOwen Dean W · Morehead, KYBuilt 1968 · S/N 585 N1842QKrause Douglas S · Davis, CABuilt 1971 · S/N 177RG0242 N1843GWincar Air LLC · Doniphan, NEBuilt 1968 · S/N 78 N1843QJohnson Dana J · Winona, MNBuilt 1972 · S/N 177RG0243 N1844GTwenty One Miles LLC · Woodland Hills, CABuilt 1968 · S/N 84 N1844QT & E Brothers Inc · Gardena, CABuilt 1972 · S/N 177RG0244 N1845MRaapana Patrick M · Fairbanks, AKFirst renewal noticeS/N 522-73 N1845VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263769 N1846QBucciarelli Tazio E · San Diego, CABuilt 1972 · S/N 177RG0246 N1847GRogers Joe E · Manvel, TXBuilt 1968 · S/N 91 N1847QDye Michael M · Bastrop, TXBuilt 1972 · S/N 177RG0247 N184JLPeters Bryan · Corpus Christi, TXBuilt 1963 · S/N 129 N1850GMadison Nicholas R · Fayette, ALBuilt 1968 · S/N 92 N1850QVincz Shawn · Williams, INBuilt 1972 · S/N 177RG0250 N18510Moore Jack B · Irvine, CABuilt 1976 · S/N 17702539 N18518Sale Reported · Waterbury, CTSale reportedBuilt 1976 · S/N 17702540 N18523Km50 Ventures LLC · Pensacola, FLBuilt 1976 · S/N 17702541 N18529Briers Scott Kevin · Conroe, TXBuilt 1977 · S/N 17702542 N1852QTalbot Mitchell R · Queen Creek, AZBuilt 1972 · S/N 177RG0252 N1854QSc Cardinal LLC · Wilmington, DEBuilt 1972 · S/N 177RG0254 N1854VSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 17263771 N1856GGray Timothy V · Clearbrook, MNS/N 12 N1856QEmpty Hanger LLC · Traverse City, MIBuilt 1972 · S/N 177RG0256 N18576Cardinal-Bird LLC · Melbourne, FLBuilt 1976 · S/N 17702543 N1857RNoetic Aviation LLC · Seattle, WABuilt 1978 · S/N R18200581 N1857VCare Central Inc · Minneapolis, MNS/N 17263772 N1858QScott Air LLC · Cave Creek, AZBuilt 1972 · S/N 177RG0258 N185ACFulton Lanny G · Spartanburg, SCBuilt 1993 · S/N 723-93 N185DCWood Ronal D Jr · Clarksville, FLS/N 2239 N185SEJensen Aviation Inc · Zephyrhills, FLBuilt 1978 · S/N 15282935 N185SRHillbilly Holler LLC · Missoula, MTBuilt 1979 · S/N 15283215 N18602Poston James M · Hixson, TNBuilt 1976 · S/N 17702544 N1862GEdwards Keith C · Gloversville, NYBuilt 1968 · S/N 649 N1862QB & P Transportation LLC · Mount Blanchard, OHBuilt 1972 · S/N 177RG0262 N1863GGriffin Robert G · Anchorage, AKS/N 108 N1863QCollins David A · Portland, ORBuilt 1972 · S/N 177RG0263 N18643Registered aircraftN-number assigned, not yet registeredS/N 17702545 N1864VFrost Dennis J · Appleton, WIBuilt 1974 · S/N 17263774 N1865GCallie Capital LLC · Prairie Village, KSBuilt 1968 · S/N 97 N1866GNicollet Flying Club Inc · Nicollet, MNBuilt 1968 · S/N 445 N1866QPez Air LLC · Cleveland Heights, OHBuilt 1972 · S/N 177RG0266 N1868GBrown Kirk W · Spring Branch, TXBuilt 1968 · S/N 109 N1868VCreative Strategies Inc · Proctorville, OHBuilt 1974 · S/N 17263775 N18694Hughes Randall L · Post Falls, IDBuilt 1976 · S/N 17702547 N1869GMcdaniel Ronnie · Starkville, MSBuilt 1968 · S/N 189 N186ACHartman James R Trustee · Everett, WABuilt 1994 · S/N 369-94 N186FMJett Aviation LLC · Clovis, NMFirst renewal noticeBuilt 1977 · S/N 17269339

Back to AD 80-25-07 R1