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.

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 N735PTCastillo Steven J · Big Bear Lake, CABuilt 1977 · S/N 18265583 N735PWN735pw LLC · Petal, MSBuilt 1977 · S/N 18265586 N735PXNalevanko Thomas A · Alpine, WYBuilt 1977 · S/N 18265587 N735PYBudrewicz Leo · Stockton, NJBuilt 1977 · S/N 18265588 N735QC7nc1 LLC · Wilmington, NCBuilt 1977 · S/N 18265592 N735QFDrouet D Aubigny Christian · Tucson, AZBuilt 1977 · S/N 18265595 N735QGBarnett Corey · Magnolia, ARBuilt 1977 · S/N 18265596 N735QHMcgraw William B · Punta Gorda, FLBuilt 1977 · S/N 18265597 N735QKClifford Tom · Forsyth, MTBuilt 1977 · S/N 18265599 N735QMGoehring Kevin · Stockton, CABuilt 1977 · S/N 18265601 N735QPCulver Marc D · Anchorage, AKBuilt 1979 · S/N U20604952 N735QRLebanon Flying Club Inc · Lebanon, TNBuilt 1977 · S/N 18265605 N735QSRtg Inc · Torrance, CABuilt 1977 · S/N 18265606 N735QWLinderman Kevin M · Washoe Valley, NVBuilt 1977 · S/N 18265610 N735QZPrecision Approach Engineering Inc · Corvallis, ORBuilt 1977 · S/N 18265613 N735RBDouglas Richard E · Wynne, ARBuilt 1977 · S/N 18265615 N735RFProchem Inc · Rockford, ILBuilt 1977 · S/N 18265619 N735RGGilfert Howard C · Mount Laurel, NJBuilt 1977 · S/N 18265620 N735RJ1700 Holdings LLC · Wayzata, MNBuilt 1977 · S/N 18265622 N735RKLegends Air Center LLC · Bentonville, ARBuilt 1977 · S/N 18265623 N735RQMiller Kyle P · Abbott, TXBuilt 1977 · S/N 18265628 N735RSEl Paso Aero Inc · El Paso, TXBuilt 1977 · S/N 18265630 N735RTN735rt LLC · New Berlin, WIBuilt 1977 · S/N 18265631 N735RWGarrett Thomas A · Wilkesboro, NCBuilt 1977 · S/N 18265634 N735RXFelton James Trustee · Canon City, COBuilt 1977 · S/N 18265635 N735SDavis Brady L · Monument, COBuilt 1959 · S/N 57013 N735SEWedig Enterprises LLC · St George, UTBuilt 1977 · S/N 18265641 N735SGClear Blue Aviation LLC · Hayden, IDBuilt 1977 · S/N 18265643 N735SKGambill Paul G II · Mulberry, ARS/N 18265646 N735SNBorn To Fly LLC · Booker, TXBuilt 1977 · S/N 18265649 N735SPKnapp James A · Casa Grande, AZBuilt 1977 · S/N 18265650 N735SRMoen Ronald C · Spirit Lake, IDBuilt 1977 · S/N 18265652 N735SXParker John S · Houston, TXBuilt 1977 · S/N 18265658 N735TBCarter Joseph J Jr · Lake Wales, FLBuilt 1977 · S/N 18265662 N735TECanir Family Partners Ltd · Port Arthur, TXS/N 18265664 N735TFForeman Gregory M · Sarasota, FLBuilt 1977 · S/N 18265665 N735TKRobinson Larry D · Dewitt, ARBuilt 1977 · S/N 18265669 N735TMHudson Valley Flight Services LLC · Pleasant Valley, NYBuilt 1977 · S/N 18265671 N735TPSailer Jacob J · Menomonie, WIBuilt 1977 · S/N 18265673 N735TRDupre Lynda M · Ligonier, PABuilt 1977 · S/N 18265675 N735TTMadera County Aircrafters · Madera, CAS/N 18265677 N735TUFerguson William R · Sedalia, MOBuilt 1977 · S/N 18265678 N735TVEl Paso Police Department · El Paso, TXBuilt 1977 · S/N 18265679

Back to AD 87-20-03 R2