AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N5107CDalrymple Michael J · San Luis Obispo, CAN5107WRugger Investment Group LLC · Sheridan, WYN5108QPardue William C Jr · Leesville, LAN5109QRmcb LLC · Kalispell, MTN510AASky West Aviation Inc Trustee · Albuquerque, NMN510WFFuel Center Plus Inc · Silver City, NMN5114QJ&A Air · Richfield, UTN5119XMission Aviation Fellowship · Nampa, IDN5119YWby Aviation LLC · Lewes, DEN511RLHatch Leasing Co LLC · Marble Canyon, AZN5120VTreaster Implement Co Inc · Beloit, KSN5120XZimmerman Tom V · North Pole, AKN5122QPyxis LLC · Cheyenne, WYN51237Infanger James Robert · Salmon, IDN5124WBest Life Aviation LLC · Cedar Park, TXN5127QRegistered aircraftN512ATRanch Aero LLC · Sterling City, TXN512GTBarron Thomas Aviation Inc · Scottsdale, AZN512SBN512sb LLC · Austin, TXN512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEN5130AAll Florida Aviation Inc · West Palm Beach, FLN5130YMerritt LLC · Leesburg, VAN5131QLeavitt Craig S · Spicewood, TXN5134WPlane Fun Inc Tr Trustee · Snellville, GAN5139QNykerk Kory · San Miguel, CAN5141QImagination Publications Inc DBA · Saratoga, WYN5144UAeronaut LLC · Saint George, UTN5146QJ&G Aero Investments Group LLC · Wilmington, DEN5146WN5146w LLC · Willow Spring, NCN514TPactolus Investments LLC · Blounts Creek, NCN5151QNotsa LLC · Morrison, CON5154AA&J Air Sales Inc · San Antonio, TXN5156QN5156q Inc · Elmhurst, ILFirst renewal noticeN5156YCaprock Spraying Inc · Vega, TXN5159ADavis Nicholas R · Madera, CAN515HE2f Trade LLC · Gainesville, TXN515RTCemco Industrial Park LLC · Belen, NMN5168ATurning Final LLC · Granby, CON5171VLisenbey Edward · Caldwell, IDN5183WG S I Training Services Inc · Branson, MON5189ABarrymore Cole · Government Camp, ORN5189YKmc Aviators LLC · Burlington, CTN518MJPursuit 53 · College Station, TXN5191VTrue Drilling LLC · Casper, WYN5194TBrown Helicopter Inc · Pensacola, FLN5195AOlson Brothers · Williams, AZN5198VMaddock Jay B · Sugar Grove, ILN51AKSchroth Charles D DBA · Gustavus, AKN51BWMcclymond Bruce W · Breckenridge, TXN51CMCorley W Michael · Mc Minnville, TN
Back to AD 2002-07-01