Skip to content

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N226CDHughes William · Woodstock, ILBuilt 2001 · S/N 1130 N226CRBentley Mooney LLC · Seattle, WAS/N 25-0570 N226LMSun Star Aviation LLC · Oshkosh, WIBuilt 2002 · S/N 3449270 N2271XSantaska Inc · Palmer, AKBuilt 1965 · S/N 337-0171 N2273XAll Florida Recovery Corp · Palm Coast, FLS/N 337-0173 N2274XDutko Adam M · Elyria, OHBuilt 1965 · S/N 337-0174 N2276MMuddy River Capital LLC · Glendive, MTBuilt 1977 · S/N 28R-7803119 N2277QComanche Aviation LLC · Chanute, KSBuilt 1977 · S/N 28R-7703060 N2279XSander Farms Inc · Wilmington, DEBuilt 1965 · S/N 337-0179 N227ALGarbar Organization LLC · Duncan, SCBuilt 1975 · S/N 34-7670028 N2281Guzman Javier A · Sammamish, WABuilt 1979 · S/N R1723129 N2284MGulf Coast Air LLC · Lakeland, FLBuilt 1977 · S/N 34-7870077 N2285MBowman Field Aviation Club Inc · Louisville, KYBuilt 1977 · S/N 34-7870078 N2286QRinker John W · Pontiac, ILBuilt 1977 · S/N 28R-7703062 N228KYPapalote Ranches LLC · Missoula, MTBuilt 1978 · S/N R1722883 N228RMitchell Warren A · Deatsville, ALBuilt 1982 · S/N 34-8233145 N228RMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 25-1230 N228TRDap Holdings LLC · Danbury, CTBuilt 2005 · S/N 1511 N2290XMatthews Roy E · Sparta, MIBuilt 1965 · S/N 337-0190 N2294XCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1965 · S/N 337-0194 N2298QGalaxy Enterprises LLC · Holdrege, NEBuilt 1977 · S/N 34-7770185 N2299XSturgeon Keith A · Saginaw, TXS/N 337-0199 N229CDGurley Eric · Omaha, NEBuilt 2001 · S/N 1131 N22CMDavis Frederich K · Dunbar, PABuilt 1965 · S/N 337-0159 N22GWSchneider Dan · Lusby, MDBuilt 1949 · S/N 3726 N22MDHolland Bryan K · Sterling, AKBuilt 1966 · S/N 337-0590 N22PNLingle Gordon D · Gun Barrel City, TXBuilt 1966 · S/N 337-0538 N22PWGoldsboro Flight Club LLC · Faison, NCBuilt 1975 · S/N 34-7570144 N22SRHillman Greg T · Riverside, CABuilt 1979 · S/N 28R-7931106 N230AAnders David W · Chandler, AZBuilt 1991 · S/N 1161 N230CDAcronut Cardinals LLC · Glen Allen, VABuilt 2001 · S/N 1121 N230DWHorwich Joshua B · Santa Clara, CABuilt 1997 · S/N HB-1 N230MAviation Developers Inc · Highlandville, MOBuilt 1984 · S/N U20606834 N2310SWest Alabama Aircraft Leasing Inc · Tuscaloosa, ALS/N 337-0610 N231ACHinsdale Jeffrey M · Ionia, NYBuilt 1979 · S/N 25-0043 N231AEJda Properties LLC · Stillwater, MNBuilt 1979 · S/N 25-0054 N231AFPistora Steven R Trustee · Lindsborg, KSBuilt 1979 · S/N 25-0064 N231AJFrimodig James P · San Diego, CABuilt 1979 · S/N 25-0082 N231AKKab Flyers LLC · Greenville, ILBuilt 1979 · S/N 25-0085 N231ALBaryon Aero LLC · Culver City, CABuilt 1979 · S/N 25-0089 N231APHoneyland Inc · Wolf Point, MTBuilt 1979 · S/N 25-0093 N231AQHenslee Christopher S · Grass Valley, CABuilt 1979 · S/N 25-0103 N231ARMabry Danny W · Morehead, KYBuilt 1979 · S/N 25-0095 N231ASSkousen Joel M · Spring City, UTBuilt 1979 · S/N 25-0106 N231ATMuncy Donald A · Corinth, TXBuilt 1982 · S/N 25-0686 N231AURouw Bruce · Leesburg, FLBuilt 1979 · S/N 25-0098 N231AYDelgado Erick · Tucson, AZBuilt 1979 · S/N 25-0099 N231AZSpirit Aviation N231az LLC · Austin, TXBuilt 1979 · S/N 25-0120 N231BADykstra Darren J · Pacific Grove, CAFirst renewal noticeBuilt 1979 · S/N 25-0073 N231BCFlying Elite Inc · Wilmington, DEBuilt 1979 · S/N 25-0112

Back to AD 81-13-10 R1