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.
N9648VGrove Kaylene · San Diego, CAN9648XWilt Michael J · Windham, NHN96490Schabacker Charles W · Jerome, IDN96491Registered aircraftN96493Smtm Holdings Inc · Wilmington, DEN9649BGoebel Christian E · Luray, VAN9649GAllen Todd N · Mccall, IDN9649VLagorce Victor X · Owasso, OKN9649XRp Aviation LLC · Plattsmouth, NEN964AAFlorida Flight Training Center Inc · Venice, FLN964AFBoerner Robert L Trustee · El Cajon, CAN964MSMount San Antonio College · Walnut, CAN964TMByrd Properties LLC · Olathe, KSN96500Granado Jose Jr · Chandler, AZN96503Miravete Paul Trustee · Saint George, UTN96505Price James Wilson · Big Stone Gap, VAN96509Aircraft Equities Inc · Wilmington, DEN9650QVon Graff Kurt · Pennington, NJN9650VPittman Michael Sr · Chandler, AZN9650XJorsey Elizabeth A · Reidsville, NCN96510T34b LLC · Seattle, WAN96515Harrill David H · Charlotte, NCN96516Quanz Bernard A · Wayland, NYN9651MGrant Aviation Inc · Anchorage, AKN9651VHussain Mahmoud Taimour Said · Miami, FLN96524Kddt LLC · Meeker, CON9652VBrown Keno · Athens, TXN96531Goldeneye Air LLC · Orange, CAN9653BSd Office Supplies & Furniture Rentals LLC · Chula Vista, CAN9653QMikeska Rudy L · Taylor, TXN9653XSchuman Karl A · Fort Worth, TXN9654BDonohue Andrew · Tulsa, OKN9654QFly Pioneer Valley LLC · Gill, MAN9654VN9654v LLC · Lakeland, FLN96551Brentco Aerial Patrol Inc · Canton, OHN9655GMiddle Fork Aviation Inc · Challis, IDN96567Gmt Aviation LLC · Newtown, CTN96568Herman Quiroga · Phoenix, AZN9656QMccort Daniel R · Pensacola, FLN9656XCivil Air Patrol Inc · Maxwell Afb, ALN96573Condor Aero Club Inc · Zelienople, PAN96575Biryukov Ruslan B · Encino, CAN96579Civil Air Patrol Inc · Maxwell Afb, ALN9657GAirmates Flying Club Inc · Northfield, NJN9657VChorman Spraying LLC · Milton, DEN96583Inconceivable LLC · Wilmington, DEN9658XSale Reported · Ozark, ALSale reportedN96590Simple Air LLC · Ankeny, IAN96594Logbook Lift Inc · Monroe, LAN96598Hawkins Curtis F · Monette, AR
Back to AD 87-20-03 R2