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.

N7548GRetro Modern Aviation LLC · Manitou Springs, COBuilt 1970 · S/N 17259248 N7548TWatkins Frank E · Montague, CABuilt 1959 · S/N 47148 N7548XKruger Daniel G · Stateline, NVBuilt 1960 · S/N 17248048 N7549MWestrum Durl T · Norwalk, IAS/N 55849 N7549XNagy Alec S · Cherry Hill, NJBuilt 1960 · S/N 17248049 N754BMPitot Heat Inc · Huntington, NYBuilt 1952 · S/N 7875 N7550G7550g LLC · Birmingham, MIBuilt 1970 · S/N 17259250 N7550MFulfer Richard S · Applegate, CAS/N 55850 N7550TShipe Jacqueline M · Louisville, TNBuilt 1959 · S/N 47150 N7550VGamblin Elton Berry · Vienna, VAFirst renewal noticeBuilt 1976 · S/N 177RG0847 N7551Delash John M · Williamson, GAS/N 50538 N75513Baird David J · Mount Shasta, CABuilt 1976 · S/N 17267773 N75515N75515 LLC · Palm City, FLBuilt 1976 · S/N 17267774 N75516Morristown Flying Service Inc · Talbott, TNBuilt 1976 · S/N 17267775 N75518Cloudhop LLC · Pinehurst, TXBuilt 1976 · S/N 17267776 N7551GNb Airdoc LLC · Aventura, FLBuilt 1970 · S/N 17259251 N7551KBoone Richard Kevin · Wichita Falls, TXBuilt 1976 · S/N 18052672 N7551SMiller Luke · Enumclaw, WABuilt 1976 · S/N 18265200 N7551XDraughon Robert W · Forney, TXS/N 17248051 N7551ZKustatan Leasing LLC · Kenai, AKS/N U20606365 N75522Bradley Alexander L · Chesapeake, OHS/N 17267779 N75529Jmw Skyhawk LLC · Midland Park, NJBuilt 1976 · S/N 17267784 N7552THaycraft James Michael · Magnolia, KYS/N 47152 N75531Garner Michael A · Hernando, MSBuilt 1976 · S/N 17267786 N75532Darrow William A · Guthrie Center, IABuilt 1976 · S/N 17267787 N75535Skyhawk Cowboys LLC · Port Angeles, WABuilt 1976 · S/N 17267790 N75536N75536 LLC · Palm City, FLBuilt 1976 · S/N 17267791 N75537Jimenez Carlos · Davie, FLBuilt 1976 · S/N 17267792 N75538Mike Moser Inc · Wilmington, DEBuilt 1976 · S/N 17267793 N7553BTri Star Aviation Inc · Nashua, NHBuilt 1977 · S/N A1520767 N7553EPolley Terri J · San Antonio Height, CAFirst renewal noticeBuilt 1978 · S/N 17272106 N7553KRichardson Richard E II · Windham, MEBuilt 1976 · S/N 18052673 N7553SFarrell David A · Milton, WIBuilt 1976 · S/N 18265202 N75548Mcfadden Edward C · Ferris, TXBuilt 1976 · S/N 17267798 N75549Matthews Raymond H Jr · Rhoadesville, VABuilt 1976 · S/N 17267799 N7554SHeard Charles R · Dothan, ALBuilt 1976 · S/N 18265203 N7554VOlson Nicholas W · Copper Canyon, TXBuilt 1976 · S/N 177RG0850 N75555American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267804 N75559Gillanders Robert Ross Personal Representative · Gig Harbor, WABuilt 1976 · S/N 17267808 N7555GSac Air LLC · Citrus Heights, CABuilt 1970 · S/N 17259255 N7555HInteraero Inc · Westlake Village, CABuilt 1981 · S/N 18267916 N7555MCamacho Daniel F · Lenexa, KSBuilt 1959 · S/N 55855 N7555VWallen Bruce R · New Britain, CTBuilt 1976 · S/N 177RG0851 N75560Nexga Aircraft Inc · Greensboro, NCS/N 17267809 N75565Flight 915 LLC · El Paso, TXS/N 17267814 N75566Wilson Robert J · Annville, PABuilt 1976 · S/N 17267815 N7556GWetlesen Gabriel C · Palmer, AKBuilt 1970 · S/N 17259256 N7556NSmith Chad R · West Plains, MOBuilt 1974 · S/N 18263245 N7556SReedm LLC · Little Rock, ARBuilt 1976 · S/N 18265205 N7556TOleskiewicz Anna · Palm Beach Shores, FLBuilt 1959 · S/N 47156

Back to AD 87-20-03 R2