Skip to content

Registered aircraft · 909

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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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.

N36RWBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000691 N373ARPaul Brightwell Dirtworks Inc · Springer, OKBuilt 1979 · S/N P21000308 N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052 N3761PSky Rollers LLC · Merritt Island, FLBuilt 1978 · S/N P21000053 N3799PCt Services LLC · Albuquerque, NMBuilt 1978 · S/N P21000055 N37AAMarine Industries Unlimited Inc · Stuart, FLBuilt 1978 · S/N 21062989 N37MJLara-Meza Sergio Giovanni · Mcallen, TXS/N P21000552 N3829PRalphs Thomas A · Solana Beach, CABuilt 1978 · S/N P21000062 N3862PBrown Travis Trustee · Columbia, MOS/N P21000065 N3886PUncanny Valley Films Inc · Arroyo Seco, NMBuilt 1978 · S/N P21000068 N38AZN731ny LLC · Phoenix, AZBuilt 1980 · S/N P21000516 N38PFSycan Corp DBA · Paso Robles, CABuilt 1980 · S/N 21063979 N3912PRegistered aircraftBuilt 1978 · S/N P21000074 N3959POmaha Aircraft LLC · Blair, NES/N P21000075 N39BEAberdeen Flying Service · Aberdeen, SDBuilt 1984 · S/N 21064889 N3EM3em LLC · Karnack, TXBuilt 1981 · S/N P21000722 N3KPAllied Asset Management LLC · Oklahoma City, OKBuilt 1981 · S/N P21000653 N401MPFriend Ships · Lake Charles, LABuilt 1979 · S/N P21000280 N403SWheeler James · Shreveport, LABuilt 1980 · S/N P21000403 N410ABBloxsom Allan P III · Boerne, TXBuilt 1979 · S/N P21000352 N4137CN4137c Inc · Redwood City, CABuilt 1979 · S/N 21063566 N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228 N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667 N433BPLeverock Richard C · Port Saint Lucie, FLBuilt 1981 · S/N P21000730 N43CPMountain View Industries LLC · Missoula, MTBuilt 1979 · S/N P21000398 N43MEEvans Matthew B · Granbury, TXBuilt 1978 · S/N P21000046 N4422NValiair Lc Trustee · Casper, WYBuilt 1978 · S/N P21000099 N4429ETwo Niner LLC · Portola Valley, CAS/N 21064709 N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647 N44475Jerryair Ltd · Kent, OHS/N P21000408 N444RWBackus Gary Carl · Chesapeake, VABuilt 1979 · S/N 21063465 N448BBHawkflight LLC · Sugar Land, TXBuilt 1979 · S/N 21063563 N44CCoyne Greg · Hondo, TXBuilt 1979 · S/N P21000311 N44ECN44ec LLC · Caddo Mills, TXBuilt 1980 · S/N 21063972 N44EEEchemann Thomas A · Sidney, OHBuilt 1979 · S/N 21063723 N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531 N4500KEaston Gregory D · Montrose, COBuilt 1978 · S/N P21000201 N450CSCbcb Aircraft LLC · Colfax, WABuilt 1979 · S/N P21000214 N450SCSky West Aviation Inc Trustee · Albuquerque, NMS/N P2100294 N450SEAok LLC · Omaha, NES/N P21000605 N4522KGoodman Jack A · Memphis, TNBuilt 1979 · S/N P21000209 N456BRPressurized LLC · Sequim, WABuilt 1981 · S/N P21000717 N4570KHead East Aviation LLC · Geneseo, ILBuilt 1979 · S/N P21000220 N4576KPope James Dean · Lewiston, IDBuilt 1979 · S/N P21000222 N4580KHarrah Daniel R · Juneau, AKBuilt 1979 · S/N P21000223 N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569 N45XDSubstation Air LLC · Midvale, UTBuilt 1981 · S/N 21064495 N4600UDlw Aviation LLC · Missoula, MTBuilt 1983 · S/N 21064789 N4601WMike Papa LLC · Newton, KSBuilt 1980 · S/N P21000622 N4608CTrinity Property Management LLC · Corvallis, ORS/N 21063572

Back to AD 98-05-14 R1