Skip to content

Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N100MSky Odyssey Aviation LLC · Gulf Breeze, FLBuilt 1975 · S/N 17265590 N100MMFarmer Aviation LLC · Milan, MIS/N 33611 N100PCSmokey Bay Air Inc · Homer, AKBuilt 1978 · S/N 20700467 N100QBShutt Ryan T · Eden, NYBuilt 1979 · S/N R18201185 N100RKEllingson Leslie B · Harwood, NDBuilt 1974 · S/N 17263551 N100SDDivan Jeremy E · Castle Rock, COBuilt 1960 · S/N 52853 N100SLOlson Gordon N · Racine, WIBuilt 1971 · S/N 18260900 N100ULEvans Hugh E · Lafayette, LABuilt 1976 · S/N A1500634 N100WAAlcorn Stanley R · Sonora, CABuilt 1964 · S/N 17251499 N100WYMcatee Mark D · Casper, WYBuilt 1959 · S/N 56439 N100YNEnrique Angulo · San Diego, CAS/N 21061236 N100YSLally Lawrence L · Mooresville, NCBuilt 1965 · S/N 17252400 N101Bene Mary D · Ketchum, OKBuilt 1964 · S/N 17252056 N10101Mcnaughton Robert R Jr · New Alexandria, PABuilt 1973 · S/N 15074794 N10105Wild Blue Aviation LLC · Eagle Rock, MOBuilt 1973 · S/N 15074797 N1010DBoggs David · Mesa, AZBuilt 1950 · S/N 7618 N1011Martin Rex L Trustee · Bakersfield, CABuilt 1980 · S/N 21064004 N1011NBlue Skies Aircraft LLC · Zephyrhills, FLBuilt 1970 · S/N 17259525 N10131Bp2 Construction LLC · Seymour, INBuilt 1973 · S/N 15074801 N10134Scarbrough Mark B · San Miguel, CABuilt 1973 · S/N 15074802 N10136Rowe Michael · Chesterfield, MOBuilt 1973 · S/N 15074803 N1013DSweeney Sean M · Reunion, FLBuilt 1950 · S/N 7621 N10141Neary John R · Ridgefield, NJBuilt 1973 · S/N 15074806 N10144Tucker Sidney L · Granbury, TXBuilt 1973 · S/N 15074807 N10146Meredith Jonathan S · Fredericksburg, VABuilt 1973 · S/N 15074808 N10148Ott James D · Kilgore, TXBuilt 1973 · S/N 15074809 N1014FPeppard Kenneth W · Dumfries, VABuilt 1979 · S/N 17272931 N1014MWeisinger Jason Aaron · Kyle, TXBuilt 1969 · S/N 15070994 N1014TInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201650 N10150Leighton Victoria A · Falmouth, MEBuilt 1973 · S/N 15074810 N1015DMickelsen Peter D · Lewistown, MTBuilt 1950 · S/N 7623 N1015FInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18502684 N1015MEppenbrock Elena C · Fort Worth, TXS/N 15070995 N1016DArdizzone Mark R · Mckinney, TXBuilt 1950 · S/N 7624 N1016FFly Cadillac LLC · Tustin, MIS/N 17272932 N1016JRoberts Nettie R · Bowling Green, KYBuilt 1968 · S/N 15068595 N1016VPlowright Aviation LLC · Aldie, VAS/N R1722082 N10171Fod Flyers LLC · Fort Dodge, IABuilt 1975 · S/N 17702315 N10176Abm Flights LLC · Pawleys Island, SCBuilt 1969 · S/N 18260141 N10177Hood Dennis M · Jonesboro, LABuilt 1973 · S/N 15074812 N10186Mckinley Brady L · Saint Joseph, MOBuilt 1973 · S/N 15074813 N1018HGulf Air Group Inc · Crestview, FLBuilt 1980 · S/N R18201649 N1019FFly By Aviation LLC · Sun Valley, CABuilt 1979 · S/N 17272933 N101APatterson Mark T · Kodiak, AKBuilt 1959 · S/N 50486 N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N101ATZrelak Patrick DBA · Apple Valley, CABuilt 1977 · S/N 15280208 N101CWAtlanta Technical College · Atlanta, GABuilt 1972 · S/N 177RG0290 N101DPStancy Marc A · Crystal Lake, ILBuilt 1967 · S/N 15067860 N101EEAlaskan Aerial Photography LLC · Anchorage, AKBuilt 1982 · S/N U20606602 N101FAStiletto Beaver Touchdown LLC · Evanston, ILS/N 15072843

Back to AD 87-20-03 R2