Skip to content

Registered aircraft · 471

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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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.

N210RPRegistration Pending · Charlestown, INRegistration pendingBuilt 1978 · S/N P21000014 N210RSInternational Air Services Inc Trustee · Carson City, NVS/N P21000147 N210SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N P21000621 N210SLKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1978 · S/N P21000129 N210SMMcconnell Peter · Valencia, PABuilt 1979 · S/N P21000370 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 N214MKoo C Carlos · Atherton, CABuilt 1985 · S/N P210-00863 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 N23KBRegistered aircraftBuilt 1985 · S/N P21000845 N242RYCity Management Corp · Sunriver, ORBuilt 1978 · S/N P21000036 N243RZBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1983 · S/N 21064961 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 N286TCJb Aviation LLC · Waxahachie, TXBuilt 1986 · S/N 21065001 N28JMWestern Aviation Services LLC · Cheyenne, WYBuilt 1979 · S/N P21000431 N2RXJbs Enterprises LLC · Hamilton, MTS/N P21000030 N305WAMy Way Aviation LLC · Weston, FLS/N 21065002 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

Back to AD 85-11-07 R1