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.

N7334PUp And Away Aviation LLC · Poughkeepsie, NYS/N P21000004 N7346PIntegrated Avionics Services Inc · Hampstead, MDBuilt 1978 · S/N P21000007 N734HW206 LLC · Portland, ORBuilt 1980 · S/N P21000602 N734VSVitatoe Industries Inc · Chillicothe, OHBuilt 1980 · S/N P21000614 N734WGStone Aviation LLC · Traverse City, MIBuilt 1980 · S/N P21000615 N734WHObermeyer Keith · Excelsior, MNBuilt 1980 · S/N P21000616 N7391PShph LLC · Edwards, ILBuilt 1978 · S/N P21000011 N739MCaurus Power Inc · Santa Rosa, CABuilt 1978 · S/N P21000063 N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279 N7559KSkyway II LLC · Naples, FLS/N P21000410 N7567KCutler Jeffrey R · Columbus, INBuilt 1979 · S/N P21000411 N75LGMarr Lance · Portland, ORBuilt 1978 · S/N P21000015 N75VRSlt Global Alliances LLC · Las Vegas, NVBuilt 1979 · S/N P21000429 N75WFSjs Holdings LLC · Los Angeles, CABuilt 1980 · S/N P21000617 N761BEAnderson Kristian L · Albuquerque, NMBuilt 1981 · S/N P21000660 N767RFAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N P21000161 N7681UTunnel Electric Inc · Shingle Springs, CAS/N 21064975 N7711GTrans Meridian LLC · Fort Myers Beach, FLS/N P21000072 N7736KValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000420 N777DLShamrock Kelly Energy Inc · Blanco, TXBuilt 1979 · S/N P21000373 N777FYQualitair LLC Trustee · ChelstadtBuilt 1979 · S/N P21000276 N77BVRegistered aircraftBuilt 1979 · S/N P21000221 N77GSSouth Carolina Flyers LLC · Aiken, SCBuilt 1981 · S/N P21000613 N77KRMarsh Aviation LLC · Old Lyme, CTBuilt 1981 · S/N P21000703 N781DBCooper Roy · Lamesa, TXS/N P21000293 N787AQHiflynal LLC · Harrisburg, ORS/N P21000844 N79DVDiscovery Associates Inc · Midland, TXBuilt 1979 · S/N P21000233 N7LVBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000506 N7MFBarger Christopher H Trustee · Mesa, AZBuilt 1980 · S/N P21000583 N800LGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000669 N818PCWindigo Transportation Inc · Waterloo, IABuilt 1982 · S/N P21000803 N81MTBennett Thomas Richard · Brooklyn Park, MNBuilt 1981 · S/N P21000794 N81VRRaviele Vincent · Richmond, TXBuilt 1986 · S/N P21000868 N824MAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N P21000763 N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541 N829BAAdaptive Resources Inc · Fort Morgan, COBuilt 1983 · S/N P21000819 N831RRFresh Farms Inc · King City, CABuilt 1986 · S/N 21064994 N833RTNash LLC · Carbondale, ILBuilt 1982 · S/N P21000809 N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633 N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578 N84MCOn-Site Mech LLC · Helena, MTS/N 21064955 N852SDauenhauer Manufacturing Inc · Ketchum, IDBuilt 1978 · S/N P21000081 N85ADEagle Eye Produce Inc · Idaho Falls, IDS/N P21000795 N86MTWhite Knuckles Aviation LLC · Carson City, NVBuilt 1980 · S/N P21000533 N888ECArrow Aviation LLC · Noblesville, INS/N P21000076 N888HFFlight1 Hsw LLC · Norwood, COBuilt 1981 · S/N P21000658 N888JWRedd Brand Aviation LLC · Twin Falls, IDBuilt 1986 · S/N P21000872 N893BWLahbak Enterprises LLC · Hilton Head Island, SCBuilt 1980 · S/N P21000498 N8EYMoore Robert Russel Sr · Austin, TXBuilt 1985 · S/N P21000850 N8KRQualitair LLC Trustee · MichelstadtBuilt 1981 · S/N P21000709

Back to AD 85-11-07 R1