Skip to content

Registered aircraft · 1,686

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:71-09-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:71-09-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:71-09-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:71-09-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:71-09-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:71-09-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.

N1655XApostolou Gregory · Henderson, NVBuilt 1975 · S/N 21060690 N1657XRowe William W · Provo, UTBuilt 1975 · S/N 21060692 N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923 N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710 N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724 N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711 N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713 N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714 N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725 N1687XMorton Douglas E · Cody, WYBuilt 1975 · S/N 21060722 N168SABruchid Snodgrass LLC · Reno, NVBuilt 1981 · S/N U20606073 N169PGHarty Joshua · Strasburg, COS/N T210-0423 N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101 N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075 N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807 N1717XSay Plastics Inc · Jacksonville, TXBuilt 1967 · S/N T2100267 N171BCR Wesley Aviation LLC · Chandler, AZBuilt 1981 · S/N 64251 N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558 N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894 N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735 N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763 N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666 N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354 N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739 N1758UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 20700358 N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378 N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744 N1786XS K Cattle Co · Manhattan, KSBuilt 1975 · S/N 21060806 N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445 N1812QLiv2fly LLC · Grand Junction, COBuilt 1975 · S/N U20602936 N1815HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 21061148 N181PKPacific Mission Aviation · Hagatna, GUS/N U20606158 N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408 N186MLIdaho Fly Girl LLC · Boise, IDBuilt 1974 · S/N U20602644 N1922TBiscoe Donald M · Cottage Grove, MNBuilt 1969 · S/N 21059220 N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312 N1968RCloud Transport Operations LLC · Albuquerque, NMS/N 21064375 N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316 N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298 N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668 N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705 N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629 N1KPSherman Loren R Jr · Granbury, TXBuilt 1973 · S/N 21060006 N1LQStrydom Cornelis F · Liberal, KSBuilt 1966 · S/N T210-0148 N200QRPdq Flight Inc · Garden City, NYS/N U20606092 N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073 N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921

Back to AD 71-09-07 R1