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.

N42292Breier Michael D · Pasco, WABuilt 1974 · S/N 17264168 N422BPreston Richard K Trustee · Albuquerque, NMS/N 17268342 N422JPWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284589 N422TTTravland Christopher L · Austin, TXBuilt 1978 · S/N R18200221 N4230QAir Castles LLC · Ozark, ALBuilt 1971 · S/N 17260130 N4232HHupp Garrett · Sunbury, PABuilt 1978 · S/N 24-0671 N4233QWoods John B · Anchorage, AKBuilt 1971 · S/N 17260133 N4234HKacprzak Dominik · Kingwood, TXBuilt 1978 · S/N 24-0673 N4234QFarr Everett L III · Bensalem, PABuilt 1971 · S/N 17260134 N4235HJunker Gregory G · Cincinnati, OHBuilt 1978 · S/N 24-0676 N42361Lima 001 LLC · Muscatine, IABuilt 1974 · S/N 17264171 N4238QFisch Markus J · Rock Falls, ILBuilt 1971 · S/N 17260138 N4239HGray Steven Don · Tualatin, ORBuilt 1978 · S/N 24-0678 N4239QElizabeth City State University · Elizabeth City, NCS/N 17260139 N423DKOliveira Avelino Da Mota · Aventura, FLBuilt 1981 · S/N R18201809 N4240QPerry Nicklette Knight · Port Arthur, TXBuilt 1971 · S/N 17260140 N4242GMaritz Paul A · Mercer Island, WABuilt 2000 · S/N 867-2000 N4242QRegistered aircraftS/N 17260142 N4244CBusking Ryan · Houston, TXBuilt 1978 · S/N R18200341 N4244HLeung Henry C · Simsbury, CTBuilt 1978 · S/N 24-0679 N4244QCox Danny · Peachtree City, GABuilt 1971 · S/N 17260144 N4245CLogan Gregory A · Chouteau, OKBuilt 1978 · S/N R18200342 N4246CDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1978 · S/N R18200343 N4246QJkg LLC · Murfreesboro, TNBuilt 1971 · S/N 17260146 N4247HRimensberger Boris D Trustee · Fullerton, CABuilt 1978 · S/N 24-0680 N4247QSchmitt Michael C · Alva, FLS/N 17260147 N4248CSchneider Franz E · Bacliff, TXBuilt 1978 · S/N R18200345 N4248HGay Arnash · Harrison, OHBuilt 1978 · S/N 24-0681 N4248QPhysics Aviation LLC · Jonesboro, ARBuilt 1971 · S/N 17260148 N424ACGilliam Robert L · Clinton, TNBuilt 1999 · S/N 418-99 N424KCCoontz James K · Melba, IDBuilt 1964 · S/N 498 N424LSQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N F177RG0130 N424MKMkt Aviation LLC · Mankato, MNBuilt 1978 · S/N 15281808 N424RESipe Scott W · Georgetown, DES/N 17275599 N424SAKcsi Aerial Patrol Inc · Bakersfield, CAS/N 456-2001 N424SCThread Head Quilting LLC · Anchorage, AKBuilt 1975 · S/N 17702367 N424WSkywarrior Flight Training LLC · Pensacola, FLBuilt 1982 · S/N 17275579 N424WMMorrison Jeffrey A · Williamson, GABuilt 1977 · S/N 17269385 N4250QTice Evan L · Seattle, WABuilt 1971 · S/N 17260150 N4251ERobbins Warren N · Chandler, AZBuilt 1978 · S/N 38-78A0507 N4252FLunn James · Winchester, CAS/N 172RG0644 N4253QFrog Av LLC · Brownstown, INBuilt 1971 · S/N 17260153 N4256HJeffers Chadwick Ray · Glencoe, ALBuilt 1978 · S/N 24-0685 N4256QBurnham Cessna N4256q LLC · Carr, COBuilt 1971 · S/N 17260156 N4258HCeason Jeffrey M · Tucson, AZBuilt 1978 · S/N 240686 N425DBWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266404 N425DLTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1979 · S/N 172RG0143 N425MKNorth Star Aviation Inc · Mankato, MNBuilt 1977 · S/N 15280650 N42609Jcr Ag LLC · Frederick, OKBuilt 1980 · S/N 18803666 N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160

Back to AD 80-25-07 R1