Skip to content

Registered aircraft · 54,017

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.

N4888G578 Airplane Leasing Inc · Kissimmee, FLS/N 17273435 N4888HRudisel Timothy A · Kewadin, MIBuilt 1979 · S/N 15283999 N4888LAshton Marc J · Petaluma, CABuilt 1980 · S/N 15284239 N48895Mulvania Rodney A · Linn, MOBuilt 1977 · S/N 15281037 N4889DPink Skies Inc · Willoughby, OHBuilt 1979 · S/N 17272387 N4889GKittitas Aero Inc · Kittitas, WABuilt 1979 · S/N 17273436 N488BAPlane Nonsense Inc · Middletown, DES/N 17273345 N488EKingdom Air Corps · Sutton, AKBuilt 1977 · S/N 15279654 N488EMBishop Patrick M · Reading, MABuilt 1965 · S/N 15062018 N488JWKagey David M · Seabrook, TXBuilt 1972 · S/N 17261113 N488RAWest Bottoms Properties Inc · Iola, KSBuilt 1977 · S/N R1722539 N488RHI F Rooks & Associates LLC · Memphis, TNBuilt 1982 · S/N U20606488 N488WMMackey Ken G · Ridgeville, SCS/N 36266 N48900Smtm Holdings Inc · Wilmington, DEBuilt 1979 · S/N 15283387 N4890FSkyline Sheet Metal Inc · Troutdale, ORBuilt 1966 · S/N U206-0590 N4890QNew Frontier Aviation LLC · Fort Benton, MTBuilt 1976 · S/N 18802626T N4890RRebecca Lynn Flying Service Inc · Livingston, NYBuilt 1975 · S/N 18802408T N48918Aero Fliers LLC · Kalispell, MTS/N 15283389 N4891EHerman Darrel K · Lebanon, ORS/N 18268281 N4891JHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1979 · S/N 17273691 N4891ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20606044 N48924Cobb Susie O · Fayetteville, TNBuilt 1977 · S/N 15281051 N48932Poursartip Nader · Hayward, CABuilt 1977 · S/N 15281056 N48935Chambers Wyatt Allan · Ludlow, MABuilt 1977 · S/N 15281059 N48938International Flying Club Inc · Winfield, ILBuilt 1977 · S/N 15281060 N4893DMazone Robert J · Deer Park, WABuilt 1958 · S/N 34993 N4893ELjl & D Inc · Wilmington, DEBuilt 1978 · S/N 17271673 N4893GBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17273440 N4893JMartineau Aircraft Inc · Butte, MTBuilt 1979 · S/N 17273692 N48941Somboonsap Patanapong · Fort Lauderdale, FLBuilt 1977 · S/N 15281062 N4894TBar Aviation LLC · Madison, ALBuilt 1981 · S/N R18201782 N4895DMissouri Aviation Inc · Leeton, MOBuilt 1958 · S/N 34995 N4895EWestern Big R Inc · Burns, ORS/N 18268282 N4895GWilson Forest B · Hollister, CABuilt 1979 · S/N 17273442 N4895VEbrite Richard P · Long Beach, MSBuilt 1980 · S/N 172RG0410 N4895YKeating George W · Fayetteville, ARBuilt 1980 · S/N 21064033 N48961Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281074 N48967N48967 LLC · Mount Pleasant, SCBuilt 1977 · S/N 15281079 N4896CFlying Paws LLC · Arvada, COBuilt 1975 · S/N 18502647 N4896DBrown Jason · Edwards, COS/N 34996 N4896EMcgrail Stephen M · South Dennis, MABuilt 1979 · S/N 18503899 N4896FPorter Carl S · Seymour, TXBuilt 1966 · S/N U206-0596 N4896GGecha Richard Mike · Florence, VTBuilt 1979 · S/N 17273443 N4896KBraxtal LLC · Kingfisher, OKBuilt 1979 · S/N P21000358 N4896MSmtm Holdings Inc · Wilmington, DEBuilt 1981 · S/N 17274294 N4896QBecker Flying Service Inc · Hartington, NEBuilt 1976 · S/N 18802632T N4896RB&R Aerial Crop Care Inc · Connell, WABuilt 1975 · S/N 18802414T N4896VSouth Aero LLC · Albuquerque, NMBuilt 1980 · S/N 172RG0411 N48972Pickett Matthew A DBA · Gig Harbor, WABuilt 1978 · S/N 15281083 N4897DHall Leah · Diamond Springs, CABuilt 1958 · S/N 34997

Back to AD 87-20-03 R2