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.

N279MASd Aviation LLC · Danville, CABuilt 2007 · S/N 1040-2007 N279RARusso Robert Michael · Pipersville, PABuilt 2005 · S/N 1392-2005 N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306 N27GFAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274608 N27HWJacobs Jim · Great Barrington, MABuilt 2018 · S/N 1177-2018 N27JSSmith Cattle Company LLC · Steamboat Rock, IABuilt 1974 · S/N 177RG0629 N27JWGaither William W · Shallotte, NCS/N 17701148 N27LASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 17265689 N27MCFratangelo Robert A · Sodus, NYBuilt 1969 · S/N 690043 N27SC5c Aviation LLC · Scottsdale, AZBuilt 1978 · S/N P21000181 N27TGHarrison Mark A · Corpus Christi, TXS/N R18201065 N27TXDavis David A · Weatherford, TXBuilt 1969 · S/N 195 N27WHAviators Unlimited Aviation Holdings LLC · Garner, NCBuilt 2007 · S/N 1045-2007 N27WKWillkris Aviation Services LLC · Smithfield, VABuilt 1972 · S/N 250-72 N2801EJ4 Aero LLC · Gulf Breeze, FLBuilt 1978 · S/N 17271327 N2801XJones Daniel L · Newton, ALBuilt 1967 · S/N 17700201 N2802JCentral States Aerial LLC · Polo, ILBuilt 1979 · S/N T18803515T N2803XStamper Douglas H · Norfolk, VABuilt 1967 · S/N 17700203 N2804CCampbell Mark · Burleson, TXBuilt 1978 · S/N R18200229 N2804ZWatson Jennifer R · San Jose, CABuilt 1978 · S/N 371-78 N2805QA L Hollandsworth LLC · Columbia, MOBuilt 1971 · S/N 17259805 N2806EBexar Aviation LLC · San Antonio, TXBuilt 1978 · S/N 17271328 N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806 N2807EMission One LLC · Excelsior, MNBuilt 1978 · S/N 17271329 N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807 N2809XGuckian Jim J · Riverdale, GABuilt 1967 · S/N 17700209 N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498 N280MAMcgarity Daniel Scott · Essex, MOBuilt 2004 · S/N 4552004 N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450 N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810 N2811GNablo Dustin · Haddam Neck, CTBuilt 1967 · S/N 170 N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812 N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212 N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813 N2815TNorwest Ventures LLC · Sagle, IDBuilt 1978 · S/N 15282250 N2815ZBarnhill Daniel D · Robertsdale, ALBuilt 1978 · S/N 356-78 N2816XCoats Christopher · Vinita, OKBuilt 1967 · S/N 17700216 N2817C2817c Inc · Wilmington, DEBuilt 1978 · S/N R18200231 N2818DSlodki David · Massapequa Park, NYBuilt 1978 · S/N 17270704 N2818ESale Reported · Lexington, NCSale reportedBuilt 1978 · S/N 17271334 N2818GRenda Joseph · Dunnellon, FLBuilt 1967 · S/N 515 N2819QAirborne LLC · Wilmington, DEBuilt 1971 · S/N 17259819 N2819XPope Steven R · Gilbert, AZBuilt 1967 · S/N 17700219 N2819ZHogan Thomas A · Fairfield, OHS/N 1236-78 N281DMBalducki James B · Signal Hill, CABuilt 1999 · S/N 1258-99 N281PCBlair Bobby G · Essex, MOBuilt 2003 · S/N 1342-2003 N281UDStanley David Wayne · Burleson, TXBuilt 1981 · S/N P21000690 N2820QBush Steven B · Lago Vista, TXBuilt 1971 · S/N 17259820 N2820XJones Michael S · Fremont, WIS/N 17700220 N2822XPender Michael J · Marsing, IDBuilt 1967 · S/N 17700222

Back to AD 80-25-07 R1