Skip to content

Registered aircraft · 6,238

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-18-06-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:87-18-06-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:87-18-06-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:87-18-06-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:87-18-06-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:87-18-06-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.

N381FGSky West Aviation Inc Trustee · Albuquerque, NMS/N EA-249 N381TCShumate Frank T · Rockport, TXBuilt 1978 · S/N TK-83 N3820LFly A Twin LLC · Kirkland, WABuilt 1981 · S/N TJ-341 N3822KPerry Park Investments Inc · Larkspur, COBuilt 1981 · S/N EA-192 N3822URegistration Pending · Stillwater, MNRegistration pendingBuilt 1981 · S/N D-10364 N3823AAndy Downs LLC · Langdon, NDBuilt 1981 · S/N EA-194 N3824XHirschauer Jeffrey · Spokane, WABuilt 1981 · S/N CE-941 N3825MMckendry Scott P · Sanford, NCBuilt 1981 · S/N E-1813 N3825XBliss Aviation LLC · Somerville, TNBuilt 1981 · S/N TH-1230 N3827QCobb Jeff B · Atlanta, GABuilt 1981 · S/N CE-942 N38282Zemetis Terence A · Meriden, CTBuilt 1981 · S/N E-1819 N3828NSallustio Eric · Lake Butler, FLBuilt 1981 · S/N E-1818 N3837WWardlay Farms And Ranches Inc · Grandview, TXBuilt 1973 · S/N TH-395 N3839RChad Gunter Enterprises LLC · Albany, GABuilt 1981 · S/N EA-199 N3839SBailey Glenn K · Englewood, COBuilt 1981 · S/N EA-210 N383PLambe Clarence Jr · Kernersville, NCBuilt 2001 · S/N E-3430 N383TTWestwood Aircraft LLC · Asheville, NCBuilt 1999 · S/N E-3274 N3840USomerset Aviation LLC · Gadsden, ALBuilt 1981 · S/N E-1821 N3840YBurrill Resources Inc · Medford, ORBuilt 1981 · S/N EA-201 N3842UBezet Danny · Comfort, TXBuilt 1981 · S/N E-1824 N3842YCole Scott A · Rockford, MIBuilt 1981 · S/N EA-204 N3843SSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N TK-139 N3844GLandvalue Management LLC · Fresno, CABuilt 1981 · S/N E-1826 N3847XCrowder Jonathan Slade · Columbus, INS/N D-10368 N3848NNicholson Philip G · Wichita Falls, TXBuilt 1997 · S/N E3098 N3848YBaron Lake LLC · Jefferson, LABuilt 1981 · S/N TJ-349 N3849XBreland Quin H · Columbia, MSBuilt 1981 · S/N E-1829 N38507Dwm Holdings Of Texas Inc · Hot Springs, ARBuilt 1981 · S/N E-1831 N3851LFreedom Aviation Of Ne Florida LLC · Jacksonville, FLBuilt 1981 · S/N E-1832 N3853JMitchell James R · Anthem, AZBuilt 1981 · S/N E-1837 N3853LZ-Tech Research LLC · Greenville, TXBuilt 1981 · S/N E-1844 N3854GDry Creek Aviation LLC · Belmont, CABuilt 1981 · S/N EA-213 N3862RToco Inc · Healdsburg, CABuilt 1981 · S/N EA-217 N3864CPearce Robert W · Santa Fe, NMBuilt 1981 · S/N E-1846 N3864UInterrail Power Inc · Jacksonville, FLBuilt 1981 · S/N TJ-355 N38650Sciorrotta Samuel C Jr · Gainesville, GABuilt 1981 · S/N E-1845 N3867GW & S Aviation LLC · Fountain Inn, SCBuilt 1981 · S/N TH-1251 N3868URegistered aircraftBuilt 1981 · S/N D-10372 N3868YTalewinds LLC · Litchfield Park, AZBuilt 1981 · S/N E-1852 N3869SPeterson Kurtley D · Gunnison, UTBuilt 1981 · S/N EA-223 N386VHGrowthland Ag Realty Inc · Humboldt, IABuilt 1972 · S/N CE-386 N3871UHolly Factory · Alachua, FLBuilt 1981 · S/N EA-220 N3872W6 Chicks Aviation LLC · Santa Maria, CABuilt 1981 · S/N EA-225 N3873BNpa Baron LLC · Gladewater, TXBuilt 1981 · S/N TH-1255 N3873JSalters James C · Montgomery, OHBuilt 1981 · S/N E-1855 N3873LScott Terry Dale · Yerington, NVBuilt 1981 · S/N E-1857 N3874YDavenport Henry B III · Charles Town, WVBuilt 1981 · S/N TH-1256 N387JKTaylor Jason E · Keller, TXBuilt 1980 · S/N E-1638 N387JRThree Eight Seven Jr LLC · Sunray, TXBuilt 2001 · S/N E-3393 N388BCAerospace Trust Management LLC · Wilmington, DEBuilt 1975 · S/N D-9786

Back to AD 87-18-06 R1