Skip to content

Registered aircraft · 4,242

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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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:89-24-01-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.

N52RBHeights Multi Flight Management LLC · Monroeville, NJBuilt 1979 · S/N 414A0302 N52SEPryor Jeff · Santa Barbara, CABuilt 1978 · S/N P21000080 N52WXGalaxy Drivers LLC · Dover, DEBuilt 1984 · S/N 468508011 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 N5316JCocola Gary M · Fresno, CABuilt 1977 · S/N 340A0405 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 N531MHigh Cotton Aero LLC · Murray, KYBuilt 1978 · S/N 340A0534 N5320JCorporate Air Charter Inc · Wilmington, DEBuilt 1977 · S/N 340A0407 N5323URio Farms LLC · King City, CABuilt 1984 · S/N 21064865 N5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A0410 N5325YBeehive Telephone Co Inc Nevada · Lake Point, UTBuilt 1980 · S/N 21064164 N5328JKahler Automation Corp · Fairmont, MNBuilt 1977 · S/N 340A0412 N532CHall Brian · Yuma, AZBuilt 2002 · S/N EA-691 N532CHWhedbee Donald Justin · Conroe, TXBuilt 1980 · S/N P21000501 N532EBJeb Air LLC · Waverly, OHBuilt 1980 · S/N 414A0440 N5337CMarc Inc · Bolton, MSBuilt 1978 · S/N 310R1543 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 N53391Schwend Brian · Forsyth, MTBuilt 1974 · S/N 18801805T N533ACEast Tennessee Aviation Services LLC · Harrison, TNBuilt 1978 · S/N 414A0103 N533STGentry Air LLC · Orlando, FLBuilt 1978 · S/N 414A0034 N533WPJacobs Aviation LLC · Mt Juliet, TNS/N 340A0328 N5340GLegal Limit Motor Sports LLC · Anderson, CAS/N 340A0421 N5340WHebel Ryan · North Potomac, MDBuilt 1981 · S/N P21000675 N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173 N5346JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 340A0419 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 N535CRScs Assets LLC · Ponce, PRBuilt 1979 · S/N 414A0244 N535MESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000345 N5362AFerguson Lynn D · Alpine, WYBuilt 1979 · S/N 21063391 N5365XSale Reported · Greeley, COSale reportedBuilt 1973 · S/N 414-0387 N5368AValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 21063394 N5369YPollard William Edward · Big Spring, TXBuilt 1980 · S/N 21064185 N536JSShoffner James P Jr · Denver, COBuilt 1984 · S/N EA-418 N5372CFlc Aviation LLC · Dyersburg, TNBuilt 1978 · S/N 414A0110 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

Back to AD 89-24-01 R1