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.
N4975LMcnabb Brandy T · Milton, FLN4975VMiller David M · Fort Worth, TXN49769Granzow Jared D Trustee · Powell, OHN4976FLytle John A · Anaheim, CAN4976GOklahoma Airmen Flying Club Inc · Jenks, OKN4976LLawrence Kenneth White · Chuckey, TNN4976PBecher Dustin Michael · Fort Wayne, INN4976SLogsdon David · Carmel, INN4976VPlane Fun Inc Tr Trustee · Snellville, GAN49778Hatfield David A · West Ossipee, NHN4977JJad Corp · Saint Cloud, MNN4977LApple Tree Aviation LLC · Gibsonia, PAN4977SMatheaus Michael · Sequin, TXN4977ZMcdorman Joshua · Collinsville, OKN49780Farrell David R · Marysville, WAN49785Wings Over Texas Holdings LLC · Denton, TXN4978BSpring City Aviation East LLC · Oconomowoc, WIFirst renewal noticeN4978GJin Jin Aviation LLC · Anchorage, AKN4978LBarr Stephen L · Spicewood, TXN4978VGeorgeson Troy D · Sheyenne, NDN49792Sierra Lima Aviation LLC · Riverton, UTN4979ESmith Corey C · Campton, NHN4979SDunn James J · San Ramon, CAN4979VRobertson Roy E · Marion, IAN497BWSwartz Taylor A · Fayetteville, NCN497DSDelaware State University · Dover, DEN497ERPlane Three Ltd · Wilmington, DEN497FLRiggin Flight Service Inc · Madison, SDN497LAPiper 3 LLC · Chestnut Ridge, NYN497LTRonneberg Dave H · Santa Monica, CAN497MShannon Michael E · Canonsburg, PAFirst renewal noticeN497SJFxe Flightcenter Corp · Fort Lauderdale, FLN49808Holloway James H · Merritt Island, FLN4980SGrenie Arles A · Richland Center, WIN4980UUniveristy Of Oklahoma · Norman, OKN4980ZElliott Charles · Rock Spring, GAN49818Wings 'N' Rotors LLC · Boise, IDN4981GGillespie John · Austin, TXN4981LBasinger Robert C · Freedom, PAN4981SLacallle Darren M · Dover, TNN4981VWasatch Industries LLC · Ogden, UTN4981ZSmith Carroll D · Ethel, LAN49821Flying Vikings Inc · Hayward, CAN49824Hillsboro Aero Academy LLC · Hillsboro, ORN49827Angel Aviation Inc · Peoria, AZN4982EDevrnja Aero LLC · Knoxville, TNN49837D&L Aircraft Leasing LLC · Ormond Beach, FLN4983FSkyventure Avaition LLC · Battle Creek, MIN4983GBrouillard Mark R · Avon, INN4983LDecoster Vaughn A · Greenwood, AR
Back to AD 90-04-06 R1