Registered aircraft · 629

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:90-07-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:90-07-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:90-07-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:90-07-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:90-07-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:90-07-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.

N867JCWoodbine Aviation LLC · Lewes, DEBuilt 1980 · S/N 550-0166 N86PCLos Veranos Companies LLC · Irvine, CAS/N 550-0891 N86URMsr Investment Properties LLC · Brentwood, TNBuilt 1988 · S/N 550-0589 N870BTdc Transportation LLC · Sylvania, OHS/N 550-0870 N872JPJssi Parts LLC · Chicago, ILS/N 550-0872 N876BBKc & Sc LLC · Forest, VABuilt 2004 · S/N 550-1087 N878CHBruce Alexander Company LLC · Elkhart, INBuilt 2003 · S/N 550-1067 N87BAUc Aviation Holdings LLC · Union City, TNBuilt 1987 · S/N S550-0131 N881SJEdwards Pacific Aviation Corp · Dover, DES/N 550-0958 N882RBGainesville Aircraft Sales Inc · Gainesville, FLS/N S550-0075 N882WFSotex II LLC · Midland, TXBuilt 1999 · S/N 550-0882 N886YSTs Sky LLC · Sellersburg, INBuilt 2002 · S/N 550-1013 N888FGTv Brothers LLC · Houston, TXBuilt 1981 · S/N 550-0298 N888RLRegistered aircraftBuilt 1981 · S/N 550-0254 N888WDEagles Wings Holdings II LLC · Canfield, OHBuilt 2004 · S/N 550-1097 N888XLStafford Mark K · Prineville, ORBuilt 1989 · S/N 5500598 N889CP1khomes LLC · Asheville, NCBuilt 1978 · S/N 550-0031 N88AJMarathon Merchant LLC · Waukesha, WIBuilt 1999 · S/N 550-0885 N88NWWnd Aircraft Management LLC · Miami, FLBuilt 1988 · S/N S550-0151 N894NTTeam Aero LLC · Olathe, KSS/N 550-0827 N896CGJet Services Inc · Mobile, ALBuilt 2003 · S/N 550-1055 N896MAQ-Sky LLC · Fairhope, ALBuilt 2003 · S/N 550-1065 N898LGGold Penny Aviation LLC · Stayton, ORBuilt 2004 · S/N 550-1080 N898SLMurphy Air LLC · Pine Bluff, ARBuilt 2000 · S/N 550-0902 N899BEcho Romeo Aviation LLC · Dallas, TXBuilt 2003 · S/N 5501073 N89DSowela Technical Community College · Lake Charles, LABuilt 1979 · S/N 550-0056 N89GAWno Trust Services LLC Trustee · Wilmington, DES/N 550-0122 N89TJSkywerx Aviation Inc · Blair, NEBuilt 1981 · S/N 551-0035 N8EBWoodbine Aviation LLC · Lewes, DEBuilt 1981 · S/N 550-0280 N900GFShb-Cb LLC · Shreveport, LABuilt 2003 · S/N 550-1046 N900LMMiller Aviation LLC · West Palm Beach, FLS/N S550-0145 N900PBFlb Group LLC · Knoxville, TNBuilt 1988 · S/N 550-0566 N904BBMmw Aviation LLC · Chesapeake, VABuilt 2000 · S/N 550-0904 N904MACjd Air Inc · Sanford, FLBuilt 2005 · S/N 550-1104 N904SJA&M Aviation LLC · Irondale, ALBuilt 1989 · S/N 5500604 N905MHScranton Christian · Walnut Creek, CABuilt 1982 · S/N 550-0454 N9072UN9072u LLC · Ocala, FLBuilt 1986 · S/N S550-0106 N909SFSayum LLC · Gonzales, CABuilt 1990 · S/N 550-0630 N90JJSurdex Corp · Chesterfield, MOBuilt 1988 · S/N 550-0571 N90PTAbnav LLC · Panama City, FLS/N 550-0465 N90ZNorthern Jet Inc · Iron Mountain, MIBuilt 1981 · S/N 550-0336 N910RBSky Charter LLC · Slidell, LABuilt 1981 · S/N 5500267 N916JRBode Aviation Inc · Albuquerque, NMBuilt 1982 · S/N 550-0343 N917BBTps Air LLC · Pembroke, NCBuilt 1983 · S/N 550-0483 N917GPEpas LLC · Wilmington, DEBuilt 1985 · S/N S5500067 N91VBParker Aviation LLC · Benson, NCS/N 550-0068 N9228ZN9928z LLC · Greeley, COS/N S550-0057 N922EHWolf Rock Industries Inc · Huntington Beach, CABuilt 1979 · S/N 551-0122 N922SLStriping Concepts Aviation LLC · Waxhaw, NCBuilt 1978 · S/N 550-0034 N923JHHarper Excavating Inc · Salt Lake City, UTBuilt 1992 · S/N 550-0708

Back to AD 90-07-10 R1