Skip to content

Registered aircraft · 54,015

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.

N84815International Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17258624 N84819Jungmeyer And Bruns Aviation LLC · Lees Summit, MOBuilt 1969 · S/N 17258627 N8481SQuigley Mark L · Nacogdoches, TXS/N 18256581 N8481TWright Eddie · Seneca, SCBuilt 1959 · S/N 52381 N8481UThree Rivers Aero LLC · Three Rivers, MIBuilt 1964 · S/N 17252381 N8481XN8481x LLC · Canyon, TXBuilt 1961 · S/N 17248981 N8481ZMoreau Lloyd J · Penrose, COBuilt 1963 · S/N 205-0481 N84823Raw Racing Inc · Puyallup, WABuilt 1969 · S/N 17258630 N84827Williams Albert J · Clayton, NCBuilt 1969 · S/N 17258631 N8482DJkt LLC · Douglas, WYBuilt 1968 · S/N 185-1370 N8482MBuck Carl R · Highland Village, TXFirst renewal noticeBuilt 1976 · S/N 18264620 N8482QGregg Flying Service Inc · Durango, COBuilt 1976 · S/N U20603340 N8482STwin Cities Aviation Inc · Blaine, MNS/N 18256582 N8482TOliver Chad · Groton, SDBuilt 1959 · S/N 52382 N84832Raven Canyon Aviation N84832 LLC · Klamath Falls, ORBuilt 1969 · S/N 17258634 N84835Boesch Leroy D II · Sebewaing, MIBuilt 1969 · S/N 17258635 N84839Lombard David S · Mariposa, CABuilt 1969 · S/N 17258637 N8483JHouston County Flying Club · Crockett, TXS/N 15066383 N8483LChickasha Wings Inc · Chickasha, OKBuilt 1968 · S/N 17256683 N8483SHolman David · Philip, SDBuilt 1965 · S/N 18256583 N8483TSiegel Andrew J · Roy, UTS/N 52383 N8483UWilson Aviation LLC · Lamar, MOBuilt 1964 · S/N 17252383 N8483ZZietz Bode W · Eastland, TXBuilt 1963 · S/N 2050483 N84840Worman Russell L · Enumclaw, WABuilt 1969 · S/N 17258638 N84849Groen Nicki M · Lynden, WABuilt 1969 · S/N 17258641 N8484GAileron Aviation Inc · Cookeville, TNBuilt 1966 · S/N 17255492 N8484JBivens Jason D · Duncan, OKBuilt 1967 · S/N 15066384 N8484QRohl Eugene A · Soldotna, AKBuilt 1978 · S/N 18503716 N8484UFarrah Gabriel E · Avon, CTBuilt 1964 · S/N 17252384 N8484ZHendrickson Todd · Woodstock, ILBuilt 1963 · S/N 2050484 N8485GWhipple James M · Wadsworth, OHS/N 15062585 N8485MFriday Harbor Wings LLC · Friday Harbor, WABuilt 1976 · S/N 18264623 N84863Pierce Aerospace LLC · Hammond, LABuilt 1969 · S/N 17258644 N8486JLysogorski Edward P · Bridgeport, MIBuilt 1967 · S/N 15066386 N8486LPockevich Dave A · Palmer, AKBuilt 1968 · S/N 17256686 N8486MSatsang Air LLC · Monterey, CAS/N 18264624 N8486SCalton Thomas C · Rutherfordton, NCBuilt 1965 · S/N 18256586 N84870Carr James B · Sarita, TXS/N 17258646 N84872Bystedt Lance H · Meridian, CABuilt 1969 · S/N 17258647 N84877N84877 LLC · Fernandina Beach, FLS/N 17258649 N84878Yankton Flyers · Yankton, SDBuilt 1969 · S/N 17258650 N84879Propwash Aviation LLC · Midland, MIBuilt 1969 · S/N 17258651 N8487JSeigler William C · Weatherford, TXBuilt 1967 · S/N 15066387 N8487SYoder Dwight D · Bear, DEFirst renewal noticeBuilt 1965 · S/N 18256587 N8487UOwens Ben E Jr · Jonesboro, ARBuilt 1964 · S/N 17252387 N8487ZBingham Neal Lee · Taylor, TXS/N 205-0487 N84888Harker Rulon J · Enterprise, UTS/N 17258655 N8488LHarrier Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N 17256688 N8488MMedia Stew LLC · Carson City, NVBuilt 1976 · S/N 18264626 N8488XRotormate LLC · Royse City, TXBuilt 1961 · S/N 17248988

Back to AD 87-20-03 R2