Skip to content

Registered aircraft · 421

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-23-03-R2') 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-23-03-R2') 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-23-03-R2')
    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-23-03-R2')
  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-23-03-R2')
  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-23-03-R2')
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.

N210SNDominguez Mark J · Many, LABuilt 1980 · S/N P21000548 N210TSGeary Inc · Westcliffe, COBuilt 1978 · S/N P21000128 N210TYRiley Charles · Littleton, COBuilt 1979 · S/N P210-00252 N210VTStricker Andreas Daniel · Essex Junction, VTBuilt 1980 · S/N P21000522 N210WWInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N P21000808 N212SBSycamore Partners LLC · Johnson, ARBuilt 1980 · S/N P21000489 N212WKRbm Adventures LLC · Jamestown, NYBuilt 1979 · S/N P21000372 N21492Puryear Rodney K · Pampa, TXS/N P21000641 N215GNBbt Jewelry LLC · Miami, FLS/N P21000335 N21BESpecialized Helicopter Training LLC · Middleton, IDBuilt 1979 · S/N P21000456 N21CTFerreira Douglas B Trustee · Chico, CABuilt 1978 · S/N P21000021 N21KRNorcon Enterprises Inc · Amarillo, TXBuilt 1979 · S/N P21000285 N21LTMission Flight · El Monte, CABuilt 1979 · S/N P21000216 N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593 N222ETValiair Lc Trustee · Casper, WYBuilt 1981 · S/N P21000626 N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089 N22VFAir Conejos LLC · El Paso, TXBuilt 1978 · S/N P21000106 N22WGCorpat Inc · Missoula, MTBuilt 1981 · S/N P21000733 N231PTLobbytools Aviation LLC · Friday Harbor, WABuilt 1980 · S/N P21000551 N234BWWaring Marvin Barton · Anacortes, WABuilt 1979 · S/N P21000290 N234SBDaly Arthur P · El Paso, TXBuilt 1981 · S/N P21000673 N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116 N242RYCity Management Corp · Sunriver, ORBuilt 1978 · S/N P21000036 N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355 N24TBDalks Leasing Inc · Wilmington, DEBuilt 1982 · S/N P21000799 N25JGCenturion Aircraft Limited · Centennial, COS/N P21000329 N25WDSale Reported · Greeley, COSale reported, canceledBuilt 1978 · S/N P21000094 N267LMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N P21000362 N26KNSky King Aviation Inc · Weslaco, TXBuilt 1978 · S/N P21000085 N26RSStacey Enterprises Inc · Ogden, UTBuilt 1978 · S/N P21000153 N278PBP21000318 Inc Trustee · Wilmington, DEBuilt 1979 · S/N P21000318 N27SC5c Aviation LLC · Scottsdale, AZBuilt 1978 · S/N P21000181 N281UDStanley David Wayne · Burleson, TXBuilt 1981 · S/N P21000690 N28JMWestern Aviation Services LLC · Cheyenne, WYBuilt 1979 · S/N P21000431 N2RXJbs Enterprises LLC · Hamilton, MTS/N P21000030 N311JBJack Brain And Associates Inc · Castro Valley, CAS/N P21000539 N313MPAlpha Bravo Charlie 1 Corp · Houston, TXBuilt 1980 · S/N P21000573 N313WTCinotto Robert L · Rhome, TXBuilt 1979 · S/N P21000350 N3153BSeverson James A Jr · Tualatin, ORBuilt 1983 · S/N P21000834 N31MDKarmy Paul Edward · Burleson, TXBuilt 1980 · S/N P21000595 N3210PKilcullen Brian DBA · Fort Lauderdale, FLBuilt 1978 · S/N P21000027 N321BLWalls Bruce · Middletown, OHBuilt 1981 · S/N P21000792 N323DCFlymax Aircraft LLC · Ball Ground, GAS/N P21000384 N339DGRegistered aircraftS/N P21000434 N34KFRsb Properties LLC · Lewes, DES/N P21000700 N34VFRomag Air Services Inc · Mc Lean, VABuilt 1979 · S/N P21000307 N350GZValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000382 N350LCDaly Arthur P · El Paso, TXBuilt 1978 · S/N P21000049 N3605PSmith Bryan · Wenatchee, WABuilt 1978 · S/N P21000040 N36RWBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000691

Back to AD 81-23-03 R2