Skip to content

Registered aircraft · 909

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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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.

N5146WN5146w LLC · Willow Spring, NCS/N P21000645 N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289 N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100 N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292 N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294 N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650 N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302 N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114 N5195AOlson Brothers · Williams, AZBuilt 1979 · S/N 21063304 N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602 N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305 N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306 N5217CHydro Wings Inc · Valle Crucis, NCBuilt 1979 · S/N 21063719 N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316 N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399 N5249ABrentco Aerial Patrol Inc · Canton, OHBuilt 1985 · S/N P21000840 N524MMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 21063717 N5252ALong Harold M · Carson City, NVBuilt 1979 · S/N 21063327 N5258ABeta Aviation L L C · Lewes, DEBuilt 1985 · S/N P21000841 N5260AN5260a LLC · Los Angeles, CAS/N 21063333 N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725 N526CHSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N P21000662 N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147 N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341 N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349 N5287YMorrow Aviation LLC · Midland, TXS/N 21064152 N528WARiley David P · South Barrington, ILBuilt 1979 · S/N P21000315 N5296AHobot LLC · Springdale, ARBuilt 1985 · S/N P21000847 N529ADDcm Air LLC · Canton, MIBuilt 1980 · S/N P21000603 N52SEPryor Jeff · Santa Barbara, CABuilt 1978 · S/N P21000080 N5300ARunzel Brothers Aviation LLC · Bensenville, ILBuilt 1979 · S/N 21063356 N5313USky Quest 210 LLC · Clarksdale, MSBuilt 1984 · S/N 21064862 N5317ABlue Skies Air LLC · Allen, TXBuilt 1979 · S/N 21063365 N5318ABuchanan Harvey · Townsend, MABuilt 1979 · S/N 21063366 N531ECBlue Jets LLC · Rialto, CABuilt 1981 · S/N P21000725 N5323URio Farms LLC · King City, CABuilt 1984 · S/N 21064865 N5325YBeehive Telephone Co Inc Nevada · Lake Point, UTBuilt 1980 · S/N 21064164 N532CHWhedbee Donald Justin · Conroe, TXBuilt 1980 · S/N P21000501 N532DGRio Farms LLC · King City, CABuilt 1983 · S/N P21000829 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 N5340WHebel Ryan · North Potomac, MDBuilt 1981 · S/N P21000675 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 N5358UMadson Chris · King City, CABuilt 1984 · S/N 21064877 N5359APalo Duro Aircraft Services Lc · Mckinney, TXBuilt 1979 · S/N 21063388 N535MESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000345 N5362AFerguson Lynn D · Alpine, WYBuilt 1979 · S/N 21063391

Back to AD 98-05-14 R1