Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N735JRSearcy Farm Supply LLC · Searcy, ARBuilt 1977 · S/N 18265465 N735JTStationair 6 LLC · Corinth, MSBuilt 1979 · S/N U20604930 N735JXBendett Michael James · Chestnut Hill, MABuilt 1977 · S/N 18265471 N735KALange Marc B · Spokane, WABuilt 1977 · S/N 18265474 N735KKLockhart Flying Club · Lockhart, TXBuilt 1977 · S/N 18265293 N735KSSquires Rodney M · Willow Creek, CABuilt 1977 · S/N 18265490 N735KTEde Transport LLC · Charleston, WVBuilt 1977 · S/N 18265491 N735KXAndrzejewski Keith D · Ridgefield, CTBuilt 1977 · S/N 18265495 N735KYJohnston Johnny C · Hernando, MSBuilt 1977 · S/N 18265496 N735KZDavis Robert L Jr · Hugoton, KSBuilt 1977 · S/N 18265497 N735LB5 Lima Bravo LLC · Bonita, LABuilt 1977 · S/N 18265499 N735LCGud Luk Cruzin LLC · Cincinnati, OHBuilt 1977 · S/N 18265500 N735LDRappaport Joel A · Round Rock, TXBuilt 1977 · S/N 18265501 N735LEReynolds Aviation LLC · Lewes, DEBuilt 1977 · S/N 18265502 N735LFHipp Air LLC · Evansville, INBuilt 1977 · S/N 18265503 N735LHBoeing Employees Flying Association Inc · Renton, WABuilt 1977 · S/N 18265505 N735LKBell Scott T · Belgrade, MTBuilt 1977 · S/N 18265507 N735LLHeath Jimmy · Lynn Haven, FLBuilt 1977 · S/N 18265508 N735LMKalman Lajos E · Spring Hill, KSBuilt 1977 · S/N 18265509 N735LQSkyview Premier Properties LLC · Stony Brook, NYBuilt 1977 · S/N 18265512 N735LSPatrick Andrew · Boise, IDBuilt 1979 · S/N U20604937 N735LTFrowe Robert · Lake Dallas, TXBuilt 1977 · S/N 18265515 N735LWEdwards Wallace · Commerce Township, MIBuilt 1977 · S/N 18265518 N735LXTraut Lake E · Riverside, CABuilt 1977 · S/N 18265519 N735LZHigh Flight Inc · Enid, OKBuilt 1977 · S/N 18265521 N735MHKxnx Holdings LLC · Cottontown, TNBuilt 1977 · S/N 18265528 N735MNCurtis Kyp · Victor, MTBuilt 1977 · S/N 18265532 N735MPHelms Aviation Inc · Long Lake, NYBuilt 1979 · S/N U20604940 N735MREdwards John S · New Port Richey, FLBuilt 1977 · S/N 18265535 N735MSPatel Chintan S · Ann Arbor, MIBuilt 1977 · S/N 18265536 N735MTGr8daynevada LLC · Carson City, NVBuilt 1977 · S/N 18265537 N735MULucas Parker D · Imbler, ORBuilt 1977 · S/N 18265538 N735MWWaddell Byron · Henderson, NVBuilt 1979 · S/N U20604942 N735MYVanderpool Robert W · Red Devil, AKBuilt 1979 · S/N U20604943 N735NCMarch Renardo · West Palm Beach, FLBuilt 1977 · S/N 18265633 N735NDNowater Aviation LLC · Worland, WYBuilt 1977 · S/N 18265547 N735NGGreen William T · Mesa, AZBuilt 1977 · S/N 18265550 N735NHN735nh LLC · Omaha, NEBuilt 1977 · S/N 18265551 N735NKWhite Jeff · O Fallon, ILS/N 18265553 N735NMLtf Aviation LLC · Urbandale, IABuilt 1977 · S/N 18265555 N735NQHughes Kelli L · Trophy Club, TXBuilt 1977 · S/N 18265558 N735NSDunn Scott R · Sandpoint, IDBuilt 1977 · S/N 18265560 N735PBHavens Harold J · Ellensburg, WABuilt 1977 · S/N 18265568 N735PDViola LLC · Monrovia, CABuilt 1977 · S/N 18265570 N735PEWalker John Leonard III · Cullman, ALBuilt 1977 · S/N 18265571 N735PHBrowning Charles H · Woodbine, MDBuilt 1977 · S/N 18265574 N735PKN735pk LLC · Story, WYBuilt 1977 · S/N 18265576 N735PMJm Aviation I LLC · Little Falls, MNBuilt 1977 · S/N 18265577 N735PRTwisted Distribution LLC · Burleson, TXBuilt 1977 · S/N 18265581 N735PSN735ps LLC · Bryan, OHBuilt 1977 · S/N 18265582

Back to AD 84-10-01 R1