Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N4907FVirginia Cherokee LLC · Leesburg, VAS/N 32-7640122 N4907JHarmon Neil A · North Chelmsford, MABuilt 1968 · S/N 28R-30625 N4907LSmooth Landin Inc · Melville, NYBuilt 1967 · S/N 28-4222 N4908JHolm R Stan · College Place, WABuilt 1968 · S/N 28R-30626 N4909SRice Philip V · Sublette, KSBuilt 1970 · S/N 28R-35681 N4910JGyure Ronald J · Fort Worth, TXBuilt 1968 · S/N 28R-30629 N4910LPeake Alexander · Tacoma, WABuilt 1967 · S/N 28-4275 N4911FFreed Michael L · Sylmar, CABuilt 1976 · S/N 28-7725035 N4911LMccown Brian W · Janesville, CABuilt 1967 · S/N 28-4276 N4912FNab LLC · Wichita, KSBuilt 1976 · S/N 28-7715079 N4912JWallace William R · Fredericksburg, TXFirst renewal noticeS/N 28R-30631 N4913LHaven Mark · Springfield, TNBuilt 1967 · S/N 28-4278 N4914FCb N4914f LLC · Coventry, CTBuilt 1976 · S/N 28-7715080 N4914LWallace Aviation Inc · Wallace, NEBuilt 1967 · S/N 28-4279 N4915JFox Richard A · Boynton Beach, FLBuilt 1968 · S/N 28R-30634 N4915LRoss Robert J · Landisville, PABuilt 1967 · S/N 28-4280 N4916JRegistration Pending · Townsend, GARegistration pendingBuilt 1968 · S/N 28R-30635 N4916LMl Monkeybar Inc · Mammoth Lakes, CABuilt 1967 · S/N 28-4281 N4916TArithansa LLC · Big Bear City, CABuilt 1972 · S/N 28-7225281 N4917JTendall Timothy A · Sudbury, MABuilt 1968 · S/N 28R-30637 N4917LBlankenbaker Myron K · Jacksonville Beach, FLBuilt 1967 · S/N 28-4282 N4918FBarnes Charles G · Louisville, KYBuilt 1976 · S/N 28-7715081 N4918JWoolley Charles K · Clarksville, TNBuilt 1968 · S/N 28R-30638 N4918LAthene Solutions LLC · Coral Springs, FLBuilt 1967 · S/N 28-4283 N49192Torii Aviation LLC · Naperville, ILBuilt 1974 · S/N 28-7410025 N4919LCroft Jeffrey W · Tennessee Colony, TXBuilt 1967 · S/N 28-4284 N491DKey City Fliers · Maquoketa, IABuilt 1973 · S/N 28-7325632 N491ETKennebeck Ronald C · Johnston, IABuilt 1968 · S/N 28-24880 N491FLWashington Fliers Inc · Pantego, NCBuilt 1971 · S/N 28-7125304 N491GShelton Christopher O · Aubrey, TXBuilt 1968 · S/N 28-25022 N4920LLvc Air LLC · Allen, TXBuilt 1967 · S/N 28-4285 N4921JHerdrich Sean D · Manchester, IABuilt 1968 · S/N 28R-30642 N4921LBarrett Howard L · Austinville, VABuilt 1967 · S/N 28-4286 N4922JOpat Randall J · Port Saint Lucie, FLS/N 28R-30643 N4922LSpanjer William H · Pine Bush, NYBuilt 1967 · S/N 28-4288 N4922TShamseldin Nathan · Buckley, WABuilt 1972 · S/N 28R-7235159 N4923LDevrnja Aero LLC · Louisville, TNBuilt 1967 · S/N 28-4289 N4924FStolee Aviation LLC · Bristol, PAS/N 28R-7635442 N4924JCarper Clyde S · New Port Richey, FLBuilt 1968 · S/N 28R-30645 N4926LRedden John V · Mooresville, NCBuilt 1967 · S/N 28-4293 N4927FRegistered aircraftBuilt 1976 · S/N 32R-7680489 N4927LProfessional Plastic Solutions LLC · Irving, TXBuilt 1967 · S/N 28-4294 N4928LTwo8lima Llp · Bryan, OHBuilt 1967 · S/N 28-4295 N4929JBurnett Robert E · San Leandro, CABuilt 1968 · S/N 28R-30650 N4929LMaak Air LLC · Wahoo, NEBuilt 1967 · S/N 28-4296 N492AGBounds Lee S · Pflugerville, TXS/N 32-40228 N492BCConsumer Collection Management Inc · Saint Louis, MOBuilt 2005 · S/N 3255037 N492BNTurner Harvey Jr · Raleigh, NCBuilt 1967 · S/N 28-4167 N492FLMcknight Anna Mae · Vernon, TXBuilt 1971 · S/N 28-7125306 N4930LG Salisbury & Associates Inc · Prescott, AZBuilt 1967 · S/N 28-4297

Back to AD 87-08-08 R3