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.

N52417Eaton Roger C DBA · Vernon, NYBuilt 1980 · S/N 17274511 N5241DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272465 N5241EBaldeo Kessho I · Bay Shore, NYBuilt 1978 · S/N 17271792 N5241JDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 17273743 N5241PAtwater John G · Vero Beach, FLS/N 15284899 N5241QWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285088 N5241TWeiss Gregory K · Colorado Springs, COBuilt 1981 · S/N R18201840 N52426Smtm Holdings Inc · Wilmington, DEBuilt 1980 · S/N 17274515 N5242DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272466 N5242RProctor Daniel L · Elkton, VABuilt 1974 · S/N 17263456 N5242XMilone Colin B · West Glacier, MTS/N 182 N52432Aftcloud Inc · Ontario, CABuilt 1980 · S/N 17274517 N52436Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274520 N52438Rick Aviation Inc · Newport News, VABuilt 1980 · S/N 17274522 N5243ECalifornia Professional Flyers Inc · Murrieta, CABuilt 1978 · S/N 17271793 N5243QCas Ltd · Swanton, VTRegistration expired, pending cancellationBuilt 1981 · S/N 15285089 N5243RDraco Flight School Inc · Chino, CABuilt 1974 · S/N 17263457 N5243XMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1969 · S/N 186 N52440Hap'S Air Inc · Ames, IABuilt 1981 · S/N 17274523 N52441Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274524 N5244EOpal Aviation LLC · Athens, GABuilt 1978 · S/N 17271794 N5244RClauson Ed P · Charlestown, RIBuilt 1974 · S/N 17263458 N5244VKnucklehead Aviation LLC · Cedar City, UTBuilt 1980 · S/N 172RG0481 N5244XFrantz William T · Wasilla, AKBuilt 1969 · S/N 184 N5245KPerun Av LLC · Cliffside Park, NJBuilt 1980 · S/N 17274029 N5245VMarianas Air Transfer Inc · Saipan, MPBuilt 1980 · S/N 172RG0482 N52465Clutter Mark R · Spencer, OHS/N 177RG1195 N5246QEast Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 15285092 N5246UMize Helicipter LLC · Edmond, OKS/N 172RG0298 N52473American Patrols Inc · Midland, TXBuilt 1980 · S/N 17274535 N52476Good Guys Flying Club LLC · Colorado Springs, COBuilt 1977 · S/N 177RG1197 N5247RHarbour Aviation LLC · Weatherford, TXBuilt 1974 · S/N 17263461 N5247XTexas Skies Flight School LLC · Boerne, TXBuilt 1969 · S/N 183 N52481Wings N Gold LLC · Lewes, DES/N 24-3089 N52483Walsh Air Enterprises · Sugar Land, TXBuilt 1980 · S/N 17274537 N52489Cardinal Club Llp · Fargo, NDBuilt 1977 · S/N 177RG1198 N5248UStephens Robert Z · Missoula, MTBuilt 1980 · S/N 172RG0300 N52493Lasky Matthew T · Constable, NYBuilt 1977 · S/N 177RG1199 N52497Hobar Geoffrey · Hoffman Estates, ILBuilt 1977 · S/N 177RG1201 N5249DQuicksilver Skycraft LLC · Langley, WAS/N 17272470 N5249EAlexandria Aviation Inc · Alexandria, MNBuilt 1978 · S/N 17271797 N5249JWhitgo LLC · Lucas, TXBuilt 1980 · S/N 17273744 N5249RHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1974 · S/N 17263463 N5249UPixley Andrew Don-George II · Rochester Hills, MIBuilt 1989 · S/N 24-3090 N524BDClark Mark · Captiva, FLBuilt 1979 · S/N 17272180 N524BTAndraos Aviation Solutions LLC · Northville, MIS/N 435-99 N524HFBa Group LLC · Glastonbury, CTS/N 15283436 N524MESmith Lester C Jr · Colleyville, TXS/N 17258149 N524MMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 21063717 N524RAMiller Seth · Lafayette, INS/N 24-3088

Back to AD 80-25-07 R1