AD 87-10-06 R1
Registered aircraft · 72,010
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
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-10-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-10-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-10-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-10-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.
N958MLLazarowicz Michael J · Port Clinton, OHN958SBVictor Foxtrot LLC · Scott City, KSN958TENewman Robert · Groton, NYN958VTMetcalfe Robert B · Flint Hill, VAN9590MRegistration Pending · Paynesville, MNRegistration pendingN9591Freelance Enterprise LLC · Clayton, WAN9591BSmith Justin T · Marshfield, WIN9591CLoera Arnold · Dillingham, AKN9591JLea Brenda A · Merriam, KSN9591MPeakland Properties Inc · Charleston, TNN9591USmolek Michael A · Saint Marys City, MDN9592DJohnson Jeremiah W · Tulsa, OKN9592LHausknecht Brian · Corpus Christi, TXN9592UN9592u LLC · Versailles, KYN9592WDreamcatcher Aviation LLC · Austin, TXN9593BBehnke Christopher H · SiegburgN9593HSaliba Bahig Nadim · Scottsdale, AZN9593JPhillips Raymond A Jr · Vestal, NYN9593KShoham Aviation LLC · Richmond, TXN9593LPeters Larry L · Sheffield, IAN9593VWeaver Robert D · Petersburg, WVN9594CPassino Nicholas J · Latham, NYN9594HEagle Sky Patrol Inc · Deadwood, SDN9594JJensen Enterprises LLC · Iola, KSN9594SRuiz Santiago · Jupiter, FLN9594UWilliams Jason R · Drums, PAN9594WMiddlecoast Air LLC · Grand Rapids, MIN9595DSchlosser Joseph V · Rockford, MNN9595JMuller Chester E · Hayward, CAN9595MRegistered aircraftN9595TWorden James L · Tucson, AZN9595UGrumman Squadron LLC · Prattville, ALN95962Forst Richard A · Sitka, AKN95965Colvin Kurt W · San Luis Obispo, CAN9596DRoss Jack H · Portland, ORN9596EKingaire LLC · Panama City, FLN9596HCorby Brenda K · Oak View, CAN9596JAstraeos Aviation LLC · Salisbury, NCN9596LPriebe John F · Troy, OHN9596UOlds Jack R DBA · Madison, INN9596WFlorida Keys Flight Academy LLC · Marathon, FLN9597BCanada Gary Jr · Coy, ARN9597JWingswat LLC · Placentia, CAN9597LRowe Richard D · Waterloo, INN9597MRegistered aircraftN9597VSkelton Jeffrey · Sioux Falls, SDN9597ZHanson James A · Bandon, ORN9598BIpsen Michael · Kenosha, WIN9598DDurden William L · Tallahassee, FLN9598HImsar LLC · Springville, UT
Back to AD 87-10-06 R1