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.

N4972AHighsmith Alfred C · Burgaw, NCBuilt 1956 · S/N 32369 N4972DPaulsden LLC · Caldwell, IDBuilt 1958 · S/N 51072 N4972FTomahawk Aviation LLC · Reno, NVBuilt 1966 · S/N U206-0672 N4972GMcchuck Properties LLC · Pensacola, FLBuilt 1979 · S/N 17273519 N4972KEastern Stearman Inc Trustee · Leesburg, VABuilt 1980 · S/N P21000388 N4972NEllis Michael J · East Wenatchee, WABuilt 1979 · S/N 18267493 N4972QAdams David G · Knoxville, TNBuilt 1978 · S/N 18503591 N4972RUnited States Air Force · Apo, APBuilt 1967 · S/N 17256326 N4972TPhilema Turf Inc · Americus, GABuilt 1981 · S/N R18201810 N4973DKilo Aviation LLC · East Peoria, ILBuilt 1958 · S/N 51073 N4973FBoraam Aviation Inc · Prospect Heights, ILBuilt 1979 · S/N 17273111 N4973UFlightpath Leasing LLC · Tallahassee, FLBuilt 1965 · S/N 21058673 N49740Horizon Aeronautics Inc · Columbia, SCBuilt 1979 · S/N 15283501 N4974DPatton John W · Mancos, COBuilt 1958 · S/N 51074 N4974GPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 17273521 N4974NCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18267495 N4974RMcpherson Marvan T · Oklahoma City, OKS/N 17256328 N4975FFg Aviation LLC · La Jolla, CABuilt 1979 · S/N 17273112 N4975GBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17273522 N4975NRegistered aircraftBuilt 1979 · S/N 18267496 N4975VMiller David M · Fort Worth, TXBuilt 1980 · S/N 172RG0440 N49769Granzow Jared D Trustee · Powell, OHBuilt 1979 · S/N 15283508 N4976DConstenius Kurt N · Tucson, AZBuilt 1958 · S/N 51076 N4976FLytle John A · Anaheim, CABuilt 1980 · S/N 172-73113 N4976GOklahoma Airmen Flying Club Inc · Jenks, OKS/N 17273523 N4976NMerlin Aviation LLC · Palisade, COBuilt 1979 · S/N 18267497 N4976PBecher Dustin Michael · Fort Wayne, INS/N 15284868 N4976UMoro Jim · Naples, FLS/N 21058676 N4976VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N 172RG0441 N4977DErdmann Gary A · North Pole, AKS/N 51077 N4977UBaker Bryan D · Anderson, CABuilt 1965 · S/N 21058677 N49780Farrell David R · Marysville, WABuilt 1978 · S/N 15281314 N49785Wings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283514 N4978BSpring City Aviation East LLC · Oconomowoc, WIFirst renewal noticeBuilt 1979 · S/N 15283736 N4978CRwr Air Inc · Tok, AKBuilt 1977 · S/N U20603870 N4978DCanterbury James A · Dixon, ILBuilt 1958 · S/N 51078 N4978FLabahn Ty L · Sherwood, ORBuilt 1966 · S/N U206-0678 N4978GJin Jin Aviation LLC · Anchorage, AKBuilt 1979 · S/N 17273525 N4978LBarr Stephen L · Spicewood, TXBuilt 1980 · S/N 15284247 N4978TRoth Robert A · Pacific Palisades, CABuilt 1981 · S/N R18201811 N4978UKempf Rodney G · Eugene, ORBuilt 1979 · S/N U20605180 N4978VGeorgeson Troy D · Sheyenne, NDBuilt 1980 · S/N 172RG0442 N4978YBohannon Donald S · Moreland, GAS/N 21064063 N49792Sierra Lima Aviation LLC · Riverton, UTS/N 15283517 N4979ARothacker Aviation LLC · Chester Springs, PAS/N 32376 N4979DTrissell Flying Service Inc · Clarksville, TXBuilt 1958 · S/N 51079 N4979RUnited States Air Force · Offutt Afb, NEBuilt 1967 · S/N 17256333 N4979VRobertson Roy E · Marion, IABuilt 1980 · S/N 172RG0443 N497RAMartin Anthony M · Beebe, ARBuilt 1967 · S/N 17256273 N49808Holloway James H · Merritt Island, FLBuilt 1979 · S/N 15283519

Back to AD 87-20-03 R2