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.

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 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 N3912PRegistered aircraftBuilt 1978 · S/N P21000074 N3959POmaha Aircraft LLC · Blair, NES/N P21000075 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 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 N44475Jerryair Ltd · Kent, OHS/N P21000408 N44CCoyne Greg · Hondo, TXBuilt 1979 · S/N P21000311 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 N4601WMike Papa LLC · Newton, KSBuilt 1980 · S/N P21000622 N4610KAvag Inc · Richvale, CABuilt 1979 · S/N P21000235 N4612KChitiea Andrew D · Centennial, COBuilt 1979 · S/N P21000236 N4617WSavoldelli Steven · Los Angeles, CABuilt 1980 · S/N P21000623 N4624KHoyt Matthew P · Newport Beach, CABuilt 1979 · S/N P21000243 N4626KWyeth Patrick B Trustee · Chino Valley, AZBuilt 1979 · S/N P21000244 N4627KIsbell Brian · Rosenberg, TXBuilt 1979 · S/N P21000245 N4629KAuburn Farms LLC · Auburn, KSBuilt 1979 · S/N P21000247 N4636KAdvanced Database Designs LLC · San Ramon, CABuilt 1979 · S/N P21000248 N4648ATimms Chet D · Central City, IABuilt 1983 · S/N P21000812 N4656KValley Agriculture LLC · Galt, CABuilt 1979 · S/N P21000251 N4671KNifong Robert B · Jacksonville, FLS/N P21000255 N4672KMartin Richard E Trustee · Colorado Springs, COBuilt 1979 · S/N P21000256 N467PZAirline Training Professionals LLC · Wilmington, DEBuilt 1980 · S/N P21000475 N4680PSchmidt Aaron B · Auburn, ALBuilt 1983 · S/N P21000814 N4695AAgarwal Ravi · Bath, PABuilt 1983 · S/N P21000816 N46CSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N P21000413

Back to AD 81-23-03 R2