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.

N525KWFuller Thomas R · Scottsdale, AZBuilt 1975 · S/N 21060881 N5260AN5260a LLC · Los Angeles, CAS/N 21063333 N5263VMccullough James M · Monte Vista, COBuilt 1975 · S/N 21060883 N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725 N5267VN5267v LLC · Northbrook, ILBuilt 1975 · S/N 21060886 N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147 N5275VViatrans LLC · Pryor, OKBuilt 1975 · S/N 21060890 N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341 N5276VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 21060891 N5277PBennett Glenn D · Kingwood, TXBuilt 1977 · S/N 21061784 N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349 N5287YMorrow Aviation LLC · Midland, TXS/N 21064152 N5300ARunzel Brothers Aviation LLC · Bensenville, ILBuilt 1979 · S/N 21063356 N5302VSniader David J · Miami, FLFirst renewal noticeBuilt 1975 · S/N 21060902 N5313USky Quest 210 LLC · Clarksdale, MSBuilt 1984 · S/N 21064862 N5314VBurke Sterling M · Olympia Fields, ILBuilt 1975 · S/N 21060905 N5314XMoody Bible Institute Of Chicago · Spokane, WAS/N U20605633 N5315XAtarah LLC · Tucson, AZBuilt 1980 · S/N U20605634 N5317ABlue Skies Air LLC · Allen, TXBuilt 1979 · S/N 21063365 N5318ABuchanan Harvey · Townsend, MABuilt 1979 · S/N 21063366 N5323URio Farms LLC · King City, CABuilt 1984 · S/N 21064865 N5325YBeehive Telephone Co Inc Nevada · Lake Point, UTBuilt 1980 · S/N 21064164 N5337YClement Aviation Inc · Tea, SDBuilt 1980 · S/N 21064171 N5338AThompson Richard T · Wilmington, OHBuilt 1979 · S/N 21063376 N5338UWatermelon Packer Ll · Mcallen, TXBuilt 1984 · S/N 21064871 N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173 N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874 N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176 N534FLeiser Harry W · Rome, PABuilt 1965 · S/N T210-0109 N5358UMadson Chris · King City, CABuilt 1984 · S/N 21064877 N5359APalo Duro Aircraft Services Lc · Mckinney, TXBuilt 1979 · S/N 21063388 N5362AFerguson Lynn D · Alpine, WYBuilt 1979 · S/N 21063391 N5363ULefore Jeffry Thomas · Milton Freewater, ORS/N U20605244 N5368AValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 21063394 N5369YPollard William Edward · Big Spring, TXBuilt 1980 · S/N 21064185 N5383ASummers Timothy P · Rincon, GABuilt 1979 · S/N 21063405 N5386ATriplett And Adams Transport Partnership LLC · New Concord, OHBuilt 1979 · S/N 21063406 N5391ASingh Amandeep · Stockton, CABuilt 1979 · S/N 21063408 N5394XL K Hollenbeak Logging Inc · Hayfork, CABuilt 1980 · S/N U20605710 N5395VCortez Flying Service Inc · Cortez, COBuilt 1975 · S/N 21060930 N53TMSmith Douglas M · Hackettstown, NJBuilt 1975 · S/N 21060762 N5401AHeadon Richard · Chino Hills, CABuilt 1979 · S/N 21063414 N5401XBarbera Frank M · Edgewood, NMBuilt 1980 · S/N U20605717 N5409YLee Christopher · Katy, TXBuilt 1980 · S/N 21064198 N5416UU S Department Of Agriculture · College Station, TXBuilt 1984 · S/N 21064890 N5416YKer Holdings LLC · Henderson, NVBuilt 1980 · S/N 21064199 N5417YFeldner Mark A · Schererville, INBuilt 1980 · S/N 21064200 N5424AFudurich David E · Goleta, CABuilt 1979 · S/N 21063428 N5424UWsol Michael P DBA · Huntington Beach, CABuilt 1979 · S/N U20605287 N5425AValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N 21063429

Back to AD 71-09-07 R1