AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N5789DTripacer Bretheren LLC · Longview, WAN5789FKarnegis Frank J · Senoia, GAN5789HBlumer Charles · Fullerton, CAN5789PNiche Pharmaceuticals LLC · Shorewood, MNN5789QWayden John R · El Paso, TXN5789WLewandowski Robert G · Crestwood, KYN578BWBridgewater State University · Bridgewater, MAN578FLChapin William C · Jackson, MIN578KAtp Aircraft 3 LLC · Wilmington, DEN578KSMisurelli Francis X · Lake Hopatcong, NJN578QWWhelchel Leon · Vinton, IAFirst renewal noticeN578RVGembala Gary L · Strongsville, OHN578SCSpartan Education LLC · Tulsa, OKN5790DJohnston Jeff · Edgewood, NMN5790FRenner Thomas F · Chandler, AZN5790LSeveca Ventures LLC DBA · Arcola, TXN5790QSurman Stephen · Draper, UTN5791DBrown Todd G · Corvallis, ORN5791FTihomirovs Dennis · Piseco, NYN5791LGuytek Aviation LLC · Margate, FLN5791WMotta Ron DBA · West Palm Beach, FLN57929Lucey William E · Salisbury, NCN5792QScott David L · Nampa, IDN5792WSchulman Henry N · Mc Ewen, TNN5793HZrelak Patrick · Apple Valley, CAFirst renewal noticeN5793UDfw Skydreams LLC · Fort Worth, TXN57940Thornton Jeffrey T · Ormond Beach, FLN57941Metropolitan Registered Pharmacists Inc · Bethalto, ILN5794HChristopherson Jack T Trustee · Overgaard, AZN5794LVanhorn Wyatt A · Macon, GAN5794UBuckley Joseph · Mora, MNN5794VHand Timothy P · Osage Beach, MON5795CHancock James T · South Saint Paul, MNN5795QStandard Charter LLC · Centennial Park, AZN5795UAg Air Squardron One LLC · Saint Joseph, ILN5795VTech Specialty Services LLC · Killeen, TXN5795WMyer Lucas O · Huntsville, ARN5796QFortier Jeremy · Alma, ARN5796ZJankow Edward W · Clinton Township, MIN5798HKroenlein Donald G · Moweaqua, ILN5798LLymburner Lawrence E · Lehigh Acres, FLN5798QBradley Brian · Las Vegas, NVN5798VHarlow Daniel E · Spotsylvania, VAN5799DBusse Charles U · Oakwood Hills, ILN5799FDunten Teri · Moses Lake, WAN5799LYoder George R · North Pole, AKN5799QHanson Bryan R · Shawnee, KSN5799URowe James H · Warrington, PAN579BWBridgewater State University · Bridgewater, MAN579DBWeiss Bernard · Saint Paul, MN
Back to AD 90-04-06 R1