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.
N5035SReady Airways LLC · Roseville, CAN5035WHennells Dann · Naples, FLN5035ZAmish Peter S · Newberry, FLN50361Mcbride Daniel · Burleson, TXN50363Dennis Steven M · Rice Lake, WIN5036GVagias Janet Rose · Niceville, FLN5036SArrow II Flyers LLC · Jacksonville, FLN5036WAeroglide Aviation Group LLC · Trenton, NJN50371Potter Michael J Jr · Fairbanks, AKN50376Hayes Brad M · Grove, OKN5037CHakel Bruce A · Fairbanks, AKN5037KD & K Aviation Inc · Milford, IAN5037NTriniair LLC · Warner Robins, GAN5037RJlinn Aviation Inc · Quinlan, TXN5037SGannon Gary L · Cumberland, WIN5037TPhoenix East Aviation LLC · Daytona Beach, FLN5037ZBoyd Christian K · Corinth, TXN50380C P Aviation Inc · Santa Paula, CAN50384Anderson Donald · Simmesport, LAN50389Sale Reported · Kissimmee, FLSale reportedN5038AWild River Flying Club · Saint Croix Falls, WIN5038CHonea Richard S · Canton, GAN5038EHohman Brent A · Fulton, SDN5038GStarros John P · Los Angeles, CAFirst renewal noticeN5038KPiercy Ronald S · Moses Lake, WAN5038LStopher Patrick K · Anchorage, AKN5038MMiller Aviation Group LLC · Coon Rapids, MNN5038PMidyett Charles O · Cambridge, MDN5038SRegistration Pending · Fort Worth, TXRegistration pendingN5038TBennett Howard N · Georgetown, KYN5038UButler Industries Inc · Amarillo, TXN5038WMarx Karl E · Juneau, AKN50395Registered aircraftN50397Wright Preston T · Deeth, NVN5039GPhronesis LLC · Tucson, AZN5039HBig Mountain Aviation Inc · Whitefish, MTN5039LGreyhawk Aviation LLC · Erie, CON5039NGutman Bradley J · Titusville, FLN5039RSmooth Landings Inc · Cary, ILN5039TMitchell Robert D · Freehold, NYN5039ZWeatherford John A · Kinder, LAN503AFAmerican Air Academy Inc · Merritt Island, FLN503AMAlpha Aviation LLC · Spartanburg, SCN503CAThompson Paul W Jr · Yachats, ORN503DMLau Wolfgang · Cap Canaveral, FLN503GLWomack Thomas G · Lonoke, ARN503JNTailwind Investments LLC · Zeeland, MIN503LWWechter William P · Ravenel, SCN503MAHobart Aviation Inc · Akron, OHN503MZWight Schuyler III · Goldsmith, TX
Back to AD 90-04-06 R1