AD 87-20-03 R2
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
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.
N9153HSambriski Michael Daniel III · Long Beach, NYN91541Engelen Patrick J · Rosamond, CAN91546Delta Charlie LLC · Meridian, IDN9154MUpupnaway LLC · Concord, NCN9154TLethal Aviation LLC · Kalispell, MTN91552Reese Ken W · Pewaukee, WIN91553Simpson Josiah J L Trustee · Shelburne, MAN91557Aero Safe Corporation · Mineral Wells, TXN91558Cole Christopher W · Bothell, WAN9155AMaki Kevin L · Saginaw, MNN9155CN9155c LLC · Palm Harbor, FLN9155MMain Line Flying Association Inc · Blue Bell, PAN91564Siudzinski David · Tuolumne, CAN91568Rasmussen Air LLC · Washington, UTN9156AStokes Jay M · Kingsland, TXN9156BRegistration Pending · Cheyenne, WYRegistration pendingN9156HSolar Flying Club · Grimes, IAN9156MJolliff Richard · Brady, TXN9156NBurdick Kenneth M · Swansea, MAN9156UHangar6 Aviation LLC · Apex, NCN91574Capps Edward F · Chaparral, NMN91576Reeves James Matthew · Corpus Christi, TXN91579Valentine Jimmie Lloyd Sr · Gulfport, MSN9157BMighells Conrad E · Randolph, NYFirst renewal noticeN9157CAims Community College · Greeley, CON9157RHolmes Ronald W · Kent, ORN9157URoss Stephen D · Greenfield, OHN91589Whittles John L · Higganum, CTFirst renewal noticeN9158CSmith Robert A · Stillwater, OKN9158HParrish Aviation Flight Academy LLC · Southlake, TXN9158MScott Richard A · Liberty Lake, WAN9158XSutton Randall D · Rexburg, IDN91592Sawatzky John E · Oakley, CAN91596West Michigan Flying Club Inc · Norton Shores, MIN9159HHess Garrett · Fullerton, CAN9159UHac Plane LLC · Sugar Land, TXN915AAHoecher Robert T · Anchorage, AKFirst renewal noticeN915CHLegacy Aire LLC · Kennesaw, GAN915CMVaayu Aviation LLC · Newark, CAN915LCardinal Flying Corp · San Jose, CAN915NGWillard Theron K · Anchorage, AKN915SCI P M Ministries · Dufur, ORN915SPThin Air LLC · Hillsboro, WIN915WBBordelon Warren P · Breaux Bridge, LAN915XKSk Aircraft LLC · Anchorage, AKN91602Kreikemeier Michael L · Belgrade, MTN91604Veeref LLC · Temecula, CAN91606Zoltak Aviation LLC · Perry, GAN91607Parreira Paul Jr · Dos Palos, CAN9160AAttitude Toys LLC · Wilmington, DE
Back to AD 87-20-03 R2