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.
N4959JTaylor James O · Marengo, ILN4959LFly Cht LLC · Chillicothe, MON4959VCutlass Cruisers Inc · Howard Lake, MNN495ABRayburn Jason A · Gibbon, NEN495ACRegistration Pending · Honolulu, HIRegistration pendingN495DBWolfson Jason · Duxbury, MAN495DVVelocity Force One LLC · Buckholts, TXN495FLUrban Thomas L · Glencoe, MNN495JCCampillo Jorge A · Miami, FLN495KLJones Christopher Brandt · Auburn, ALN495LAPiper 3 LLC · Chestnut Ridge, NYN495PLIntegrity Aircraft Title Holdings LLC · Portland, ORN495SPFlying Start Aero Services LLC · Reno, NVN495TMMacdonald Kenneth A · Willow, AKN495WDaniel Zachary T · Mckinney, TXN4960LWynn Wora A · Scottsdale, AZN4960ZTeterboro School Of Aeronautics Inc · Virginia Beach, VAN4961GGardner Clifton T · Vernal, UTN4961JJones Charles W · La Follette, TNN4961KGirolami Philip · Fircrest, WAN4961LKral Aircraft LLC · Ocala, FLN4961THatami-Nezhad Jamshid · Encino, CAN4961YSprenger Michael T · Hawley, MNN49621Albertson James M · Westville, FLN4962BUniversity Of Maryland Eastern Shore · Princess Anne, MDN4962GVersteeg Martin · San Antonio, TXN4962HKelly William W · Springfield, ORN4962JHuffman Jacob M III · Burleson, TXN4962LCypret Phillip B · Sacramento, CAN4962VAircraft Partner Holdings Inc Trustee · BerlinN4963GSunwest Aviation Inc · Santa Ynez, CAN4963LBakk Dale A · Nikiski, AKN49645Wilson Archie Clark · Hernando, FLN49649C & T Aviation Holdings Inc · Mckinney, TXN4964GCrotts Aircraft Service Inc · Dodge City, KSN4964JShteyn Vladlmir · Huntingdon Valley, PAN4964LMcallister Robert G · Santee, CAN4964PGregory Kristen · Vallejo, CAN4964ZYoung Jimmy D · Watson, ARN49654Herman Brian · Wrangell, AKN49658Wilson Archie Clark · Hernando, FLN4965LCentral Air Parts Inc · Staunton, ILN4966GSonger Charles W III · Tuscaloosa, ALN4966LNelson Osea C · Sheridan, WYN4966ZIberlin John P · Gillette, WYN4967BUniv Of Illinois Bd Of Trustees · Savoy, ILN4967JB F D Inc · Newington, CTN4967NKubinski Kenneth B · Eastover, NCN4967SLambert Enterprises Inc · Minneapolis, MNN4967TN4967t LLC · Evansville, IN
Back to AD 90-04-06 R1