Skip to content

Registered aircraft · 6,916

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N1406TCitabria Inc · Auburn, CABuilt 1972 · S/N 28R-7235280 N1407TAndrews University · Berrien Springs, MIBuilt 1972 · S/N 34-7250311 N1410TWelch Bruce E · Boyce, VABuilt 1972 · S/N 28R-7235281 N1411TCable Marsha A · Toronto, OHBuilt 1972 · S/N 28R-7235282 N1411XMaarouf Dan H · Seabrook, TXBuilt 1975 · S/N 34-7570239 N1412HAsherbranner Charles E · Yucaipa, CAS/N 28R-7737003 N1416XTop Tier Truck And Trailer LLC · Dimmitt, TXBuilt 1975 · S/N 34-7570241 N1418XHaskin Kent B · Claverack, NYBuilt 1975 · S/N 28R-7535276 N1419TBrolan Aviation LLC · Kansas City, MOS/N 28R-7235283 N1421TBurr Charles R Jr · Palm Bay, FLBuilt 1972 · S/N 34-7250314 N1424NEbonaster Enterprises LLC · Slidell, LABuilt 1966 · S/N 24-4383 N14258Bayshore Aviation LLC · Saint Petersburg, FLS/N 34-7350180 N1425TSkydance Aviation LLC · Norfolk, VABuilt 1972 · S/N 28R-7235286 N1429XRegistered aircraftBuilt 1975 · S/N 28R-7535278 N142CATack Kenneth W · Taft, CABuilt 1959 · S/N 24-1161 N142EN142e LLC · Page, AZBuilt 1967 · S/N 30-1479 N142GDDeaero LLC · Darwin, MNBuilt 1980 · S/N 34-8070314 N142MHAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28R-7335230 N1430XRuggiero Matthew J · New York, NYBuilt 1975 · S/N 28R-7535279 N1433TTilton Dave P · Bradyville, TNS/N 28R-7235287 N1434TStrickland Jason · Gulfport, FLBuilt 1972 · S/N 28R-7235288 N1436TDeland Aviation LLC · Deland, FLBuilt 1972 · S/N 34-7250317 N1437HFry Dennis Charles · Anaheim, CAS/N 32R-7780160 N143MMPalo Michael Scott · Melbourne, FLBuilt 1970 · S/N 39-18 N143PBHemdmm Corp · Wilmington, DEBuilt 1977 · S/N 28R-7703243 N1440XAlldredge Brad · Redlands, CABuilt 1963 · S/N 24-3478 N1444XWaddell Charles · Elk Grove, CABuilt 1975 · S/N 28R-7535283 N1445TWhelan And Sons Realty LLC · Suffield, CTBuilt 1972 · S/N 28R-7235290 N1447TDa Silva Paulo E · Orlando, FLS/N 28R-7235292 N144TLNielson Mark Allen · Willmar, MNBuilt 1959 · S/N 24-1205 N1450RSammy Shwan · Danvers, MABuilt 1972 · S/N 28R-7335060 N1451XTrb Aviation Inc · Washington, DCBuilt 1975 · S/N 34-7570248 N1455XAviation Capital Management LLC · San Jose, CABuilt 1975 · S/N 28R-7535285 N1456XYoung Daniel J · Cedarburg, WIBuilt 1975 · S/N 28R-7535286 N1463HPrickett John M · Manchaca, TXS/N 28R-7703026 N1467XWilson David K · Mckinney, TXBuilt 1975 · S/N 34-7570252 N1468THindle John Charles IV · Whitehouse Station, NJBuilt 1972 · S/N 28R-7235296 N1469TThree Wing Flight School LLC · Stratford, CTBuilt 1972 · S/N 28R-7235297 N146PWilliams Mike C · Sonora, TXS/N 24-366 N1470HCherokee Air Inc · Lexington, SCS/N 32R-7780162 N1472TGreen Lakes Aviation LLC · Belton, SCBuilt 1972 · S/N 28R-7235298 N1479TWnc Aviation LLC · Arden, NCBuilt 1972 · S/N 28R-7235302 N147BZSpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 34-7870359 N147LHSchool Board Of Brevard County Florida · Melbourne, FLBuilt 2003 · S/N 2844103 N1481XBadgerland Aero Club Inc · Fitchburg, WIBuilt 1975 · S/N 28R-7535289 N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290 N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291 N148PFMacallen Chemical Inc · Monroe, LABuilt 1978 · S/N 34-7970017 N148RFPaklook Air Inc · Bethel, AKBuilt 1976 · S/N 32R-7680076 N148SBGriner Warren D · Pinson, ALBuilt 1966 · S/N 30-1148

Back to AD 97-01-01 R1