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.
N46746Dunlap Gary P · Seattle, WAN46748Roscioli Lamberto · Lighthouse Point, FLN4674ZHoadley Todd F · Springfield, OHN4675JRegistration Pending · Gardnerville, NVRegistration pendingN4675RLatham Cary · Hardin, KYN46760Caterinichio Gasper D · Eagle River, AKN46762Kay Bennie L · Brigham City, UTN46764Hatbright Farm LLC · Wilmington, DEN4676FSt Pete Aviation Services LLC · Saint Petersburg, FLN4676WZaid LLC · Windermere, FLN4676ZNielsen Nancy A · Eugene, ORN46773Macannamac Inc · Millinocket, MEN46775Lookner Augustus · Owls Head, MEN4677RFields Michael L · Rockwood, TNN4677SSchutt Michael J · Kimberling City, MON4678RRegistration Pending · Vadnais Heights, MNRegistration pendingN4678ZQrh LLC · Bartlesville, OKN46798Shermer Darlene Francis · Brooklyn Park, MNN4679GFlightime Inc · Elkhart, INN4679HAdams Kris · Griffin, GAN4679WBravo Whiskey LLC · Cascade, CON467AArcher Aircraft LLC · Wilmington, DEN467AT467at LLC · Frankfort, ILN467CMIasco Flight Training Inc · Redding, CAN467DKRegistered aircraftN467FAMain Line Flight School LLC · Haverford, PAN467GRRoach Gene T · Frankfort, KYN467PEOkane James K · Noblesville, INN467QStegner John J · Boonville, MON467TFHarts Joel D · Coffeyville, KSN467WPPalmer Thomas T · Kapowsin, WAN46803Ken Graham Phd Inc · Sioux Falls, SDN4680JCorral Oscar L · Ft Stockton, TXN4680RGibbs Robert I · Ravenswood, WVN4680ZPropelling The Gospel Missions Inc · Standish, MEN4681JRose Jeffrey R · Niceville, FLN46826Registration Pending · Tampa, FLRegistration pendingN46828Petro Jerry R · Williamsburg, VAN4682DBusch Craig D · Green Brook, NJN4682JAhz Aviation LLC · Shawnee, KSN4682RTremblay Stanley R Sr · Dexter, MEN4683TBatchelor William · Sicklerville, NJN46846Boudreau Robert D · Rusk, TXN4684CSmith Cameron T · Placitas, NMN4684HHarvey Robert C · Hortonville, WIN4684JByrne Matthew A · West Allis, WIN4684ZGordon Stephen M · Velpen, INN46854Phillips Joe Christopher · Grand Prairie, TXN4685JGaither William W · Shallotte, NCN4685SSeneca Aeronautical Services LLC · Wilmington, DE
Back to AD 90-04-06 R1