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.

N435RTBloom Mark W · Miami, FLBuilt 1965 · S/N 667 N4360QStoll Paul C · Blossom, TXBuilt 1971 · S/N 17260260 N4360RGrasshopper Flying Club Inc · Poughkeepsie, NYBuilt 1974 · S/N 17263111 N4361HSazhin Michael · Brooklyn, NYBuilt 1978 · S/N 24-0720 N4362QQuacker Holdings LLC · Aspen, COBuilt 1971 · S/N 17260262 N4362RBruther Thomas J · Temecula, CABuilt 1974 · S/N 17263113 N4363RSky Walker Flight School LLC · Adrian, MIBuilt 1974 · S/N 17263114 N4365QJackson Rickey L · Edmond, OKBuilt 1971 · S/N 17260265 N4365RCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1974 · S/N 17263116 N4366RHyland Mark R · Poland, MEBuilt 1974 · S/N 17263117 N436ACKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 2000 · S/N 411-2000 N436RMRocky Mountain College · Billings, MTBuilt 1979 · S/N 17273662 N4370RSkar Paul R · Londonderry, NHBuilt 1974 · S/N 17263121 N4372RKennemer Farms Inc · Carter, OKBuilt 1978 · S/N R18200594 N4373RKlc Associates · Unionville, CTBuilt 1978 · S/N R18200595 N4374HAlexander Chang Lee · Menifee, CAS/N 24-0721 N4374QWillaero LLC · Union City, TNBuilt 1971 · S/N 17260274 N4376QFranke Russel G · Silt, COS/N 17260276 N4377QStacey James · Exeter, MEBuilt 1971 · S/N 17260277 N4377RDallas Aero & Sales LLC · Poplar, MTBuilt 1974 · S/N 17263127 N4378QWings Flying Club Inc · South Bend, INBuilt 1971 · S/N 17260278 N4379QHagaman Edward T · Tolland, CTBuilt 1971 · S/N 17260279 N4379RSlipstream Aviation LLC · Calera, ALBuilt 1974 · S/N 17263129 N437ACHaggerty Kevin B · Bozeman, MTBuilt 1998 · S/N 393-98 N437PHHolske Peter John · Dartmouth, MAS/N 17267933 N4381QAero Wise Services LLC · Decatur, TXBuilt 1971 · S/N 17260281 N4381RDugan James M · North Bend, OHS/N 17263131 N4382QLegends Air LLC · Wilmington, DES/N 17260282 N4382RMoranski Joseph F · Budd Lake, NJBuilt 1974 · S/N 17263132 N4383QBladen Aviation Inc · Elizabethtown, NCBuilt 1971 · S/N 17260283 N4384QMorten John E · Larimore, NDBuilt 1971 · S/N 17260284 N4384RAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263134 N4385QKulis Richard W · Gill, MABuilt 1971 · S/N 17260285 N4385RAnderson Kenneth J · Norman, OKBuilt 1974 · S/N 17263135 N4386RFlying H LLC · Lake Placid, FLBuilt 1974 · S/N 17263136 N4387EAlbergotti James M III · Orangeburg, SCBuilt 1978 · S/N 38-78A0585 N4387QCrose Merrill L · Sibley, MOBuilt 1971 · S/N 17260287 N4388RSunrise Aviation Inc · Ormond Beach, FLBuilt 1974 · S/N 17263138 N4389QMellinger Jason C · North Pole, AKS/N 17260289 N438ACHickerson Timmy D · Greenfield, INBuilt 2000 · S/N 438-2000 N4390QFlying Mermaid LLC · Aiea, HIBuilt 1971 · S/N 17260290 N4390RBrown David R · Kent, WABuilt 1974 · S/N 17263140 N4391QSpringville Flying Club · Spanish Fork, UTBuilt 1971 · S/N 17260291 N4391RCheek Kenneth W · Yadkinville, NCBuilt 1974 · S/N 17263141 N4392QRose Denver W · Eubank, KYBuilt 1971 · S/N 17260292 N4393QJkj Aviation LLC · Wilmington, NCBuilt 1971 · S/N 17260293 N4393RHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17263143 N4394HFarabaugh Mark J · Owego, NYBuilt 1978 · S/N 24-0723 N4394QAircraft Resource Center Inc · Lakeville, MNBuilt 1971 · S/N 17260294 N4395HHorizontal Aviation Ltd Inc · Pinehurst, NCS/N 24-0724

Back to AD 80-25-07 R1