Skip to content

Registered aircraft · 57

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:94-15-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-15-13') 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:94-15-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-15-13')
  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:94-15-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-15-13')
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.

N1111KBlue Monkey Disposing & Recycling Inc · Tampa, FLBuilt 1983 · S/N 60-8365021 N111DZDelta Hotel LLC · Griffin, GABuilt 1982 · S/N 60-8265014 N1225Fox R Bruce · Kennesaw, GAS/N 61P05727963249 N12NWSodeog LLC · Plantation, FLS/N 60-8265013 N144SJTrigger Down LLC · Virginia Beach, VABuilt 1978 · S/N 61P-0545-233 N177AFMcgee Aviation LLC · Yorktown, VABuilt 1984 · S/N 60-8423022 N19BROttopilot LLC · Lewes, DEBuilt 1982 · S/N 60-8265043 N201WFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1984 · S/N 608423010 N250SRm Av-Med Consulting LLC · Baton Rouge, LAS/N 60-8265004 N28BPHvs Enterprises LLC · Durango, COS/N 60-8365017 N338NEldor Industries Inc · Toledo, OHBuilt 1982 · S/N 60-8365008 N3635ACaljet Inc · Van Nuys, CABuilt 1980 · S/N 61P07748063387 N3AGManaged Aviation Inc · The Villages, FLBuilt 1983 · S/N 60-8365018 N419BCVagabond LLC · Baton Rouge, LABuilt 1982 · S/N 60-8265045 N440BANo More Jump Seats LLC · Bowling Green, KYBuilt 1982 · S/N 60-8365002 N473TDManaged Aviation Inc · The Villages, FLBuilt 1983 · S/N 60-8365013 N51EPEsa Montana LLC · Boulder, COBuilt 1982 · S/N 60-8265018 N529RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1984 · S/N 60-8423004 N555PXWindsock Holdings LLC · Amarillo, TXBuilt 1982 · S/N 60-8265028 N600BAJacks Express LLC · Wilmington, DEBuilt 1982 · S/N 60-8265024 N601NGBullard Aviation Services Inc · Ormond Beach, FLBuilt 1980 · S/N 61P07908063402 N601PSchmidt Richard E · Fort Myers, FLBuilt 1979 · S/N 61P06587963306 N602PAYagen Gerald · Virginia Beach, VAS/N 60-8265009 N602WKStrange River Inc · Dripping Springs, TXBuilt 1983 · S/N 60-8365019 N611EFCentral Air Service Inc · Lewistown, MTS/N 60-8365005 N626NPValli Aviation LLC · Tallahassee, FLS/N 60-8423014 N62DGShiloh Air LLC · Spokane, WAS/N 60-8265040 N64715Yardley Management Ltd · Johnstown, PAS/N 60-8365003 N64717Top Aviation Services Inc · Weston, FLBuilt 1982 · S/N 60-8265039 N65966Registered aircraftBuilt 1990 · S/N 0534226 N68980Connected Aviation LLC · Peoria, ILBuilt 1982 · S/N 60-8265012 N6898WSarah Business LLC · Wilmington, DEBuilt 1982 · S/N 60-8265008 N6899RDavenport Henry B IV · Berryville, VABuilt 1982 · S/N 60-8265017 N6900TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 60-8265027 N6903RFusion Marine Inc · Stuart, FLS/N 60-8365015 N69LPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 61P-0541-0230 N700DXPickett Herbert Timothy · Flagstaff, AZS/N 60-8423013 N700EEMatteo Properties Inc · Wickliffe, OHBuilt 1982 · S/N 60-8265021 N700TEAustin Bill DBA · Sparta, TNBuilt 1982 · S/N 60-8265015 N700VWCondor Aviation LLC · Bethlehem, PABuilt 1984 · S/N 60-8423012 N700WZPinto Robert · Sicklerville, NJBuilt 1984 · S/N 60-8423007 N701HBBlaire William C · Rch Palos Vrd, CABuilt 1984 · S/N 608423015 N702GPUniversal Investors LLC · Independence Chate, MIBuilt 1983 · S/N 60-8365001 N702PGOn Three Angels Wings LLC · Melbourne, FLBuilt 1984 · S/N 60-8423009 N702RJStites Holdings LLC · Seattle, WAS/N 60-8423011 N707JPSierra Hotel Inc · Van Buren, ARS/N 60-8423018 N711TLBarne George H · Lexington, KYBuilt 1984 · S/N 608423017 N728RTBurnside Jack · Rockwall, TXBuilt 1978 · S/N 61P05627963243 N77FPRegistration Pending · New Richmond, WIRegistration pendingS/N 60-8265047 N7988HTc Loox Consultants LLC · Washington, DCBuilt 1984 · S/N 60-8423021

Back to AD 94-15-13