Skip to content

Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N735JCAvfun LLC · San Antonio, TXBuilt 1977 · S/N 18265452 N735JDVulcan Engineering · Bloomington, CABuilt 1977 · S/N 18265453 N735JFSchneider Ruth Ellen · Durango, COBuilt 1977 · S/N 18265455 N735JGBritt David J · Somerset, KYS/N 18265456 N735JKMashman Edward A · Los Angeles, CABuilt 1977 · S/N 18265459 N735JNWehrman Milton W · Hunter, KSS/N 18265462 N735JQHeppe Dale · Lynn Haven, FLBuilt 1977 · S/N 18265464 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

Back to AD 87-20-03 R2